3 Conditions

[Laurie B.]

I have tried and tried and can only get one conditon to work and that is the first one. I have all text in the spreadsheet there are no numbers.
Examples would be
Column A Column C
NED NED Match color would be green
NED CLE no match color would be blue
NED Column c is blank color would be red

I am using 2007, Conditonal formatting, Manage Rules, New rules.

= Exact (A5,C5) format Green
=If Column A <> Column C format Blue
=If Column B isblank format Red

I am looking to highlight the entire row if possible and have these conditions for the entire sheet.

Thank you.
Laurie B.

[Catalin.B]

=If Column A = Column C format Blue formula =EXACT($A1;$C1) applied to: =$1:$100
=If Column A <> Column C format Blue formula =EXACT($A1;$C1)=FALSE applied to: =$1:$100
=If Column B isblank format Red formula =ISBLANK($B1) applied to: =$1:$100
note: if you don't lock the column in formula with $ sign (not the row ), the format will not work as intended...
check file attached...

[Laurie B.]

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.

[Laurie B.]

Catalin,
I just went back into those blank cells and pressed delete and the conditional formatting worked - those rows are turning red now. The cells must have had a space in them? I am guessing I'll need to go through and make sure all the blank cells are really blank.

Laurie B.

[Catalin.B]

Laurie, another reason for conditional formatting to not work, is the right order of the rules applied... In your case, the "red" rule must be first in your "rules order". When this happends, go to manage rules, and move up the rule which is not working.
Good luck..