Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Folks,
I am trying to build a tracking product for training events that are accomplished and those that are due. I want to have a cell that turns from Green Yellow Red, based on a timeframe that I pick. Example: John Doe completes yearly Egress training on 1-18-2008 that cell will remain Green until 3 months from his due date and then the cell will turn Yellow. At the date that Egress training is due again the cell will turn Red until the training is completed. I hope that I have not confused anyone your help in this will make my job easier to track upcoming and overdue training. -- RGM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date sensitive cell pattern color | Excel Worksheet Functions | |||
How to set up a date sensitive notification? | Excel Discussion (Misc queries) | |||
How to set up a date sensitive notification? | Excel Discussion (Misc queries) | |||
how do i make a cell date sensitive to execute a formula or input. | Excel Discussion (Misc queries) | |||
Trying to make cell "date sensitive" to specific date | Excel Discussion (Misc queries) |