Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Based on Date
How can I change the fill color of a cell based on a date. I would like the
cell to be green if the date in a cell is equal to or greater than 90 days from todays date. Yellow if less than or equal to 90 days and Red if less than or equal to 30 day from the current date. This is to track when an employee's annual training is due. -- Aloha, Ron A. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format based on date | Excel Worksheet Functions | |||
Conditional Sum based on Bold Format | Excel Discussion (Misc queries) | |||
how do you conditional format based upon today's date? | Excel Worksheet Functions | |||
Conditional Format based on date ranges | Excel Worksheet Functions | |||
Conditional Format based on range | Excel Discussion (Misc queries) |