Ok.....I thought I had this figured out but its not doing anything!
In a sheet I have a column for a date....Ex 12/1/09 -------- I would like to have the cell change color after it passes 75 days for the date thats in the cell....Example, 12/1/09 changes to yellow after todays date passes (for round numbers) 2/15/10............And then turn red after 90 days from 12/1/09-------------
I used the formula as follows and I believe it should work but nothing happens. Please assume that A1 is the desired cell to change.
Went to Format - Conditional formatting -
Formula (A1+90)<TODAY() changed the format to color the cell red
Formula (A1+75)<TODAY() changed the format to color the cell yellow.
Please help.....nothing happens......I checked TOOLS----OPTIONS----Calculations-----Auto.......Its ok so I think....
Any ideas,,,,,,,,THANK YOU SO MUCH!