2 conditions using conditional formatting
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.
|