2 conditions using conditional formatting

[Guest]

I would like a cell to change colour for 2 separate condidtions. Cell C1 is
default cell colour grey. 1st condition is Cell C1 to change to white if A1
= "No". 2nd condition is C1 to change to yellow if A1 = "No" and B1 = "3rd
Party". I have tried putting these in as 2 separate formulae in the
Conditional Formatting but only condition 1 works ie C1 stays white even when
"3rd Party" is in cell B1.

Any help appreciated.

 

[Guest]

this is a logic problem. here is the truth table for your problem

Cell A1
No Yes
No 3rd Party White Grey
B1
3rd Party Yellow Grey


You nee three forula in conditional formating

1) grey if A1 = Yes
2) White if A1= No and 3rd Party = No
3) Yellow is A1 = No and 3rd Party = yes

 

[Jon Peltier]

It can be simpler than this. The first condition below is unnecessary. The
real first condition is yellow if A1="No" and B1="3rd Party". The second
condition is white if A1="No".

- Jon

 

[Guest]

Thanks for the reply. It worked perfectly

It can be simpler than this. The first condition below is unnecessary. The
real first condition is yellow if A1="No" and B1="3rd Party". The second
condition is white if A1="No".

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______