30-60-90 days conditional formula help

[uh60chief]

Cell S52 has a date, how do I get it to change green when the entered date is 45 days or less old, 46 to 90 days or less old change yellow, and change red when the entered date is 90 days or over?

 

[guerillaunit]

You can use conditional formatting. In Excel 2002 / 2003, go to "Format" → "Conditional Formatting"

 

[uh60chief]

I get that but I am not getting the formula to make it work right.

 

[guerillaunit]

0-45 days:

=TODAY()-$A$1 < 46

46-90 days:

=AND(TODAY()-$A$1 > 45, TODAY()-$A$1 < 91)

Over 90 days:

=TODAY()-$A$1 > 90

 

[uh60chief]

Thanks for the help.

 

[uh60chief]

It looks like the less then 45 days old, and the older then 90 formula is working but the 46-90 day one is not. Any other formulas for this?

Never mind I can't count