How do I flag a cell in Excel 2002 when the date entered has pass

S

sas1950

I need to flag either a cell or a cell next to it to fill with a color when
the original cell date has passed a set number of days, i.e., original cell
is 1/3/06, flag date would be 7 days out.
 
C

Cutter

Use Conditional Formatting

In the cell containing the date, for the condition use:
Cell value is - less than - =TODAY()-6

Apply your formatting
 
Top