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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting of dates in two cells using Excel 2007
Select cell A2
Select conditional format - formula Enter the following forumla =AND(B2<TODAY(),C2="") Set the required format then OK/apply etc until exit conditional format Copy Cell A2 Paste Special - Formats to the remaining cells to have the conditional format. In lieu of copy - paste special you can also select the entire range to format before opening conditional format just so long as you ensure that A2 is the active cell (The first cell in the selection or one that stays white in the selection). You then enter the formula as if only applying it to only one cell A2 exactly as above. -- Regards, OssieMac |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting of dates in two cells using Excel 2007
1. Select the Range (say A1:A10) or column A. Please note that the cell
reference A1 mentioned in the formula is the active cell in the selection. Active cell will have a white background even after selection 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =AND(B1<TODAY(),C1="",A1<"",B10) 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK If this post helps click Yes --------------- Jacob Skaria "lemur99" wrote: 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 |
Reply |
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 |