Conditional Formatting Dates based on number of days that have passed

[fatstrat]

I am trying to figure-out how to set up conditional formatting of dates in a column (e.g. Date Submitted) and have these dates, and/or cell, change color as time progresses. I have Excel 2007.

For instance I have an application submitted on 11/20/2011 in a cell. I would like to have the date change color (Yellow) after 30 days have passed.

Then do the same except change to Red after 60 days have passed the date.

I searched the forums and did not find this particular problem. I of course may have missed it too...

My guess was to try "$A$1<=Today()-30" assuming the date to be formatted is in cell A1. This did not work.

Any ideas would greatly appreciated.

Thanks,
Steve

 

[vaskov17]

"=today()-30" (no quotes) should work as the "LESS THAN" condition, for all the selected cells

 

[LxQ]

take the quotation marks off, Excel puts it there for me too and I have to manually go in and remove them.. see if that helps

 

[mgm05267]

Hi fatstrat,

use conditional formating cell contains greater than or equal to & use formula "=today()-30"
and add another condition cell contains greater than or equal to & use formula "=today()-60"

Hope this is what your requirement is .....

Regards,

MGM

 

[fatstrat]

All,

Thanks for your help. I got it to work!

The quotes did not help things...

Steve