| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting based on Today's Date
Hi,
I am making a spreadsheet with due dates and completion dates on it. I want to format the due dates to show up as on-time (green) or late (red) based on today's date. Once the step is completed (a completed date is entered) I want the color to stop changing based on today's date (and just stay the color it was at time of completion. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| Conditional Formatting Based on Date | Excel Worksheet Functions | |||
| multiple If's based on today's date | Excel Worksheet Functions | |||
| how do you conditional format based upon today's date? | Excel Worksheet Functions | |||
| Conditional Formatting Based on Date | Excel Discussion (Misc queries) | |||
Threaded Mode
