Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Windows XP SP2, MS Excel 2003.
I have a project plan that has target and actual date columns. Format is 03/02/05. Would like to highlight the planned date cell if it is within 2 days of todays date in yellow AND the actual date cell is blank. If the Actual date is filled in, then no formating of the Planned date cell. If the planned date is = or than today and the actual date field is blank, format the planned date cell RED. Any help would be greatly appreciated Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formating For a Date | Excel Discussion (Misc queries) | |||
More Planned and Actual Cycle Times | Excel Worksheet Functions | |||
how do I do a Planned vs Actual start date & end date graph | Charts and Charting in Excel | |||
how do I do a Planned vs Actual start date & end date graph | Charts and Charting in Excel | |||
Conditional formating w/ Date | Excel Worksheet Functions |