Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have the following for a conditional formatting statement for a row
Formula Is =AND(ISBLANK)$L7),(TODAY()$J7)) in order to highlight the row yellow when the Date Closed cell (L7) for the item is blank and the Closure Due Date (J7) has passed. The row is highlighting when it is completely blank, with no data filled in. I have only the headers typed in the appropriate columns, and am using the format painter to format all my rows, and they are all highlighting yellow... I have two other conditions set up with two other colors. The one giving me the issue is Condition 2. Condition 1: Formula Is =$L7<"" So that the row highlights grey once the item has a Date Closed entered. Condition 3: Formula Is =OR($F7(TODAY()+730),ISBLANK($F7)) So that the row highlights orange if the last time the item has been serviced was more than two years ago or there is no record of when it was last serviced (F7 being the date of last service). Any idea why Condition 2 is coming up True, and highlighting yellow, when the row is completely blank and there is no information to determine if the condition is True or False? Thanks, Deanna |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 - Conditional Formatting applied to Pivot Tables | Excel Discussion (Misc queries) | |||
In Excel, can Boolean logic be applied to conditional formatting? | Excel Worksheet Functions | |||
can conditional formatting be applied in more then three instance | New Users to Excel | |||
Conditional Formatting not applied to data exported from Access | Excel Worksheet Functions | |||
counting cells with conditional formatting applied | Excel Discussion (Misc queries) |