Quote:
Originally Posted by bbutl027
I have done this but all the cells are coming up yellow. Unless I have entered them wrong. I have entered the following dates just to check the conditional formatting.
A1: 3/4/14
A2: 4/4/14
A3: 5/4/14
A4: 6/4/14
With conditional Formatting:
cell value less than =today()+365-90 yellow
cell value less than =today()+365-60 amber
cell value less than =today()+365+30 red
cell value greater than =today()+91 green
This is correct?
|
You have to make sure you have the order right for the conditions. Also I'm not entirely clear on those equations as I've had a few adult beverages. Attach your file and I'll take a gander tomorrow.