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 -
1st condition.
Formula (A1+90)<TODAY() changed the format to color the cell red

2nd condition.
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!