| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell color changes when date gets closer
Hi:
I have a large spreadsheet that I track employee training on. The cells contain the DUE date of next training I would like to format it so that if a training date is past the DUE date the cell color is "red". If the date is within 0-30 days the cell is "amber", and if it is within 31-60 days of DUE date then "yellow". Many thanks for you help.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Due date - change cell color | Excel Worksheet Functions | |||
| Cell color date sensitive | Excel Discussion (Misc queries) | |||
| Cell colors or text color changing when date in cell gets closer. | Excel Worksheet Functions | |||
| labels closer to axis | Charts and Charting in Excel | |||
| cell color change based on due date | New Users to Excel | |||
Threaded Mode
