How to change color of cell as dates pass

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to automatically go to the right of the last colored cell 0
Update cell value based on name and specific date 1
changing cell background colors with formulas 5
Formatting Help 1
Date Conditional Formatting 4
Update a date into the same cell? 10
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Function for summing or counting cells based on a specified fill color 2

Back
Top