Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick Question
I am creating a spreadsheet for work to track when employees have completed
training. When the main date changes and the date on the employee don't match I want the fill to self generate to red and green when training is accomplished. Is this possible. Don't want a value like with a if statement but just a fill to highlight it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick Question
Hi Kory,
I'm not completely clear about what you want precisely but it sounds like conditional formatting will do what you want and here are a couple of example to get you going. To enter these select cell (in this case A1) Format|Conditional Formatting - Select formula is from the dropdown and enter these formula and select a colour =A1 < TODAY()-1 Changes cell colour if it is earlier than today =A1 < TODAY()-1 Changes cell colour if it is later than today =A1 < D1 Changes cell colour if it is earlier than the date in D1 etc Mike "Kory" wrote: I am creating a spreadsheet for work to track when employees have completed training. When the main date changes and the date on the employee don't match I want the fill to self generate to red and green when training is accomplished. Is this possible. Don't want a value like with a if statement but just a fill to highlight it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quick Question | Excel Worksheet Functions | |||
quick question | Excel Discussion (Misc queries) | |||
Quick little question | Excel Discussion (Misc queries) | |||
Quick Question | Excel Worksheet Functions | |||
Quick Question | Excel Discussion (Misc queries) |