| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format: Expired dates wanting cell to change color
I have a chart that displays when tasks have been completed, when they are
due, and at what interval the task is required to be renewed by. My question is i want the cell of the due date to change to red and for the text "overdue" to be in yellow, when that due date goes past the interval of when it was completed by. If anyone can help me get out of this bind i would appreciate it Dan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format: Expired dates wanting cell to change color
Hi-lite all of the cells that might have overdue in them and then use
conditonal formatting. Format....conditonal format....cell value: is equal to overdue then click on the format area and choose yellow for the font and red for the pattern "Dan" wrote: I have a chart that displays when tasks have been completed, when they are due, and at what interval the task is required to be renewed by. My question is i want the cell of the due date to change to red and for the text "overdue" to be in yellow, when that due date goes past the interval of when it was completed by. If anyone can help me get out of this bind i would appreciate it Dan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| Cell color change without using conditional formatting | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
Linear Mode
