=AND( in conditional formatting

  • Thread starter Thread starter Gaurav
  • Start date Start date
G

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.
 
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.
 
Thanks All.

David Biddulph said:
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.
Click to expand...
 
Back
Top