View Single Post
 
Old 12-06-2017, 09:29 AM
Diana09 Diana09 is offline Windows 10 Office 2013
Novice
 
Join Date: Dec 2017
Posts: 3
Diana09 is on a distinguished road
Default How to use conditional formatting for two criteria?

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.
Reply With Quote