How to change color of cell as dates pass
 

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?

How to change color of cell as dates pass
 

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


"jeanne" wrote:

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?