| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
turn a cel a color based o todays date
Projected dates left to right drom D5:N5
Actual dates are entered one at a time below projected date as a project ends in D6:N6 The answer goes in D7:N7 All works fine. 1. If Todays date exceeds Projected date =1 day ie: Expected 2/11/09 and Today is 2/12/09 2. I'd like to turn "That Cell" in D6:N6 Blue, (not all cells,) just the Cell that exceeds the date based on Today. =1 3. When a date IS entered into a BLUE D6 rows cell, I would like the cell to look normal, turn the BLUE OFF and show the date entered. Can this be done? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofill cell based on todays date | Excel Worksheet Functions | |||
| Making a Cell turn color based on results in another cell | Excel Discussion (Misc queries) | |||
| Need to set a cell that if it has a date typed then turn color | Excel Worksheet Functions | |||
| If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
| Setting traffic lights based on todays date against target dates | Excel Discussion (Misc queries) | |||
Threaded Mode
