LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default Conditional Formatting Applied when Statement Not True

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 - Conditional Formatting applied to Pivot Tables Elsa L. Excel Discussion (Misc queries) 0 November 26th 07 11:20 AM
In Excel, can Boolean logic be applied to conditional formatting? PeterL Excel Worksheet Functions 3 October 26th 06 08:16 PM
can conditional formatting be applied in more then three instance Mary jane New Users to Excel 2 December 21st 05 04:02 AM
Conditional Formatting not applied to data exported from Access Mark A Excel Worksheet Functions 5 October 24th 05 12:11 PM
counting cells with conditional formatting applied HalB Excel Discussion (Misc queries) 3 February 21st 05 01:21 PM


All times are GMT +1. The time now is 03:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"