Hi All,
I have the following dilemmas:
1. If cells "A3-A1000" value > cells "B3-B1000" value would like to display "Incline" in cells "C3-C1000" and opposite if < to show "Decline"?
2. One new tab added each corresponding month (Jan, Feb, Mar etc) with new data. First tab ("Annual") has a sum of all months data. I would like in tab "Annual" to have a new column that will highlight the increase or decrease from the previous month numbers with the above conditional formatting showing an arrow up/down or word "Incline"/"Decline" instead of value.
Thank You so much for input.
I have the following dilemmas:
1. If cells "A3-A1000" value > cells "B3-B1000" value would like to display "Incline" in cells "C3-C1000" and opposite if < to show "Decline"?
2. One new tab added each corresponding month (Jan, Feb, Mar etc) with new data. First tab ("Annual") has a sum of all months data. I would like in tab "Annual" to have a new column that will highlight the increase or decrease from the previous month numbers with the above conditional formatting showing an arrow up/down or word "Incline"/"Decline" instead of value.
Thank You so much for input.