ON 19-12-2009 Ray wrote in microsoft.public.excel.worksheet.functions:
Try this
Conditional formating:
Condition1:
Cell value is greater than =TODAY()+28, Format Red
Condition 2:
Cell value is greater than =TODAY()+21, Format Yellow
Condition 3:
Cell value is greater than =TODAY(), Format Green

Regards
Lars Klintholm

I want to be able to make the cell change a color when the date entered into
the cell has reached one of the three time lines: Green: Dates between date
in cell and 20 days after, Yellow: Date 21 days after date in cell, and Red:
Date 28 days after date in cell. I know how to change the color but the date
formulas are giving me trouble. Any help would be appreciated. Thanks.