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.

"Mike" wrote:

Does this work

Select the cell and conditional formatting

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

"Renee" wrote:

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