How to use conditional formatting for two criteria?

[Diana09]

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.

[Pecoflyer]

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

[Diana09]

Originally Posted by Pecoflyer

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

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!!

[Pecoflyer]

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

[Diana09]

Originally Posted by Pecoflyer

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

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.