Conditional formatting for <45, 45-90, >90 Days

Greetings,

I am trying to establish conditional formatting in order for the color of a cell to be based on a <45, 45-90, 90> condition so that it applies to a date column ('Documents Updated'!$C$2:$C$32) in 2011 Excel for MAC as follows:

=TODAY()-C2 < 46 ...... then color of cell = green
=AND(TODAY()-C15 > 45, TODAY()-C15 < 91) ..... then color of cell = yellow
=TODAY()-C2 > 90 ...... then color of cell = red



Both the green and red conditions seem to be working as intended but the yellow condition is changing the cell to white (unshaded) verses yellow.

I even went through the effort of setting up "test" cell to see if the condition for this formula is TRUE/FALSE. For the yellow condition, the cell shows TRUE so the formula seems to be correct yet the color of the cell doesn't change colors. If I set a date outside of this range, it changes red/green as expected.


Any suggestions would be greatly appreciated.

Is there some reason why you are referencing cell C15 for that condition, as the other conditions refer to cell C2 ?

Hope this helps.

Pete