=AND( in conditional formatting

[Gaurav]

Hi All,

I need 3 conditions. I have applied 2 which are simple ones but cant seem to
figure out the third one.

Condition 1 - If C2="y" then color the row yellow. (Done)
Condition 2 - If E2="y" then color the row green. (Done)
Condition 3 - If C2="y" and E2="y" then color the row blue. (Not done)

So the third condition is the one I need help for.

Thanks in advance.

 

[Don Guillett]

try
formula is
=and($c$2="y'",$e$2="y")

 

[Rick Rothstein \(MVP - VB\)]

And it can also be done without using AND...

=$C$2&$E$2="yy"

Rick

 

[Don Guillett]

clever!!

 

[David Biddulph]

But it's no good putting Don's formula as the 3rd condition, as the
conditions are applied in the order listed. If condition 3 is true, it
never gets there because 1 and 2 are both satified earlier.
2 options:
1 Put what is currently your 3rd condition as the first in your list.
2 Change your conditions 1 and 2 to say =AND(C2="y",E2<>"y") and
=AND(E2="y",C2<>"y") respectively.

 

[Gaurav]

Thanks All.

But it's no good putting Don's formula as the 3rd condition, as the
conditions are applied in the order listed. If condition 3 is true, it
never gets there because 1 and 2 are both satified earlier.
2 options:
1 Put what is currently your 3rd condition as the first in your list.
2 Change your conditions 1 and 2 to say =AND(C2="y",E2<>"y") and
=AND(E2="y",C2<>"y") respectively.