Thread: [Solved] 3 Conditions
View Single Post
 
Old 08-15-2011, 11:52 AM
Laurie B. Laurie B. is offline Windows XP Office 2007
Novice
 
Join Date: Feb 2011
Location: New Jersey
Posts: 7
Laurie B. is on a distinguished road
Default

Catalin
Thank you for such a quick reply.

I was able to get the two Exacts to match but the Isblank condition is not working. I even put them in the order that you had yours, Red, Blue, Green.

It doesn't matter what is in Column A, I just need the condition to be if cells C5 and down are blank or null highlight the row.

Is it because the condition =Exact($A5,$C5) = False already has those rows highlighted in Blue? For example, Column A could have a name in that cell and Column C be blank or Column A and C could have names in each cell but they don't match.

In this case should there need to be different conditions? It is strange that the ISBlank condition is working. The cells appear to be blank. Here's an example. Line 3 should be red because Column C is blank.
Exact084ExactNot_Exact105Not ExactIsBlank104

=ISBLANK($C5) =TRUE applied to =$5:$6389
=EXACT($A5,$C5) applied to =$5:$6389
=EXACT($A5,$C5)=FALSE applied to =$5:$6389
I'll keep plugging along for now. I am sure I'm doing something wrong.
Thanks again for your help.
Laurie B.
Reply With Quote