Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
I have created a spreadsheet of various dates of when my employees annual
trainings are due. I would like the cell color to change based on how many days to their training is due. If the renewal date is more than 60 days away I would like the cell one color, if the renewal date is 60 days to the date it is due, the cell would be a different color if the renewal date is past due it would be a third color. The cells are in m/dd/yy format. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting by % of whole | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |