Conditional formatting with 2 criteria

Solved
Sly3d Posted messages 4 Status Membre -  
Sly3d Posted messages 4 Status Membre -
Hello,

I found several topics corresponding to this title, unfortunately I always come across the same conditions...

Here’s my problem:

In H5 (for example), I apply a conditional formatting that says "If the cell next to it (G5) is empty, and H5 is empty, the condition is false (or true, anyway it doesn't apply the color change (that's my settings), but if cell G5 is not empty, there are 2 possibilities: Either H5 is empty, and it shows the format change, or the cell is filled and the formatting remains unchanged."

To summarize, if G5 is empty and H5 is empty, no formatting; if G5 is filled and H5 is empty, formatting; and if G5 and H5 are filled, no formatting.

I tried with =AND(G5<>"", H5="") and =IF(AND(G5<>"", H5=""), TRUE, FALSE)

But as soon as both G5 and H5 are empty, it "doubles" the formatting (the cell turns redder). Would you know how to tell Excel that with H5 and G5 empty, it should not apply the formatting?

Thank you in advance,
Sly

Configuration: Windows 7 / Chrome 26.0.1410.64

3 réponses

f894009 Posted messages 17417 Registration date   Status Membre Last intervention   1 717
 
Hello,

=(AND(G5<>""; H5=""))
4