Hello

I would like to use conditional formatting (or other hypothesis) for the following:
If one cell has "yes" and the other has "-", format with red color. I'm not getting.
I tried the formula: If in the cell has "yes" and in the other has "-", write in another cell "no" and based on this "no", format in red. But I didn't want it to be like this.



Thank you for your attention and for your help.

Basically the CF would be =AND($A1="yes",$A2="-") applied to the cell/range you need to color

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Oh really so easy ...
So many hours to try to solve! I was not getting the "and" in the right place. It was not working.
Thanks!!

You're welcome. I've seen many folks having problems with the AND function. Always easiest to check a function's syntax first.

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Yes, and no doubt the problem was syntax. Because the "and" was there, but it was not in the right place. I tried putting it in various ways and it did not work at all.
It's solved and I'm already applying on multiple worksheets.
Thank you for your help.