Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting of dates in two cells using Excel 2007
Hi,
I've got a spreadsheet set up as: Column A - task Column B - Expected completion date Column C - Actual completion date and I want to set it up so that all tasks that have not yet been completed but should have been are highlighted in red (that is, for example, if B2< todays date and C2 is blank then A2 is highlighted red). I've been messing about but can't seem to get it right in the conditional formatting - any suggestions? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting cells with dates | Excel Discussion (Misc queries) | |||
Conditional formatting based on the sum of two cells (Excel 2007) | Excel Discussion (Misc queries) | |||
Conditional formatting dates in 2007 | Excel Worksheet Functions | |||
HELP - Conditional Formatting Dates & Blank Cells | Excel Worksheet Functions | |||
Conditional Formatting in for Cells with Mixed Dates and Text | Excel Worksheet Functions |