| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
| conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
| SQL - Auto Refresh Upon Cell Value Change | Excel Worksheet Functions | |||
Linear Mode
