Conditional Fomarting

R

Renee

I am wanting to put a conditional formating on cell A2 to highlight it red if
cell B2>0 and cell C2 is blank, but highlight it green if B2>0 and C2=YES.
I hope this makes sense. Thanks for your help in advance.
 
M

Mike

Does this work

Select the cell and conditional formatting

if formula is =AND(B2>0,C2="") Set to red
2nd condition press ADD
If formula is =AND(B2>0,C2="Yes") set to green
 
R

Renee

I put this condition on and my cell has stayed white, the cell I tried it on
should turn red. Then I tried a cell that should be green and it stayed white
as well.
 
S

SteveW

Make sure you have YES or Yes in the formula and the Cell C2

And similar make sure the cell C2 is empty and doesn't contain a blank or
space

Steve
 
B

Bob Phillips

Had you selected A2 before?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Top