Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting for past due dates
For an Action Items log, I need to create a conditional format that
highlights a row in red when the completion date is past due. The conditional formating for completed tasks (grey) and "today's" tasks (yellow) are in place. I'm just looking for a formula for past due dates. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting for past due dates
See http://www.xldynamic.com/source/xld.CF.html#due
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Annabelle" wrote in message ups.com... For an Action Items log, I need to create a conditional format that highlights a row in red when the completion date is past due. The conditional formating for completed tasks (grey) and "today's" tasks (yellow) are in place. I'm just looking for a formula for past due dates. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - dates | Excel Discussion (Misc queries) | |||
conditional formatting with dates | Excel Worksheet Functions | |||
Help with Conditional Formatting (Dates) | Excel Discussion (Misc queries) | |||
Conditional Formatting & Dates? | Excel Discussion (Misc queries) | |||
conditional formatting dates | Excel Discussion (Misc queries) |