How to change color of cell as dates pass

J

jeanne

I have a schedule that has dates in it. As the dates pass, I want to fill in
the cell so that you know to go to the next step. How do I do that?
 
E

Elkar

You can use Conditional Formatting.

Select your range of cells.
From the Format Menu, select "Conditional Formatting..."
Set your condition, perhaps select "less than" and enter =TODAY()
Set your format
Click OK

HTH,
Elkar
 
Top