Conditional Fomarting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
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
 
Had you selected A2 before?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Back
Top