Search code examples
google-sheetsgoogle-sheets-formula

Google Sheets conditional formatting with AND function not working

I am hoping that you can help me out with a google sheets conditional formatting error. I am trying to combine the below formulas with the and function. Separately they work. But combined they do not.

Any help would be great. I have been struggling with this simple formula for too long!

Thanks

Separate formulas:

=($A111<>"") =(isblank($F111))

COMBINED:

=AND((isblank($F111)), ($A111<>""))

Solution

  • Try removing extra parenthesis:

    =AND(isblank($F111),$A111<>"")

    Changing locale, commas with semi-colons:

    =AND(isblank($F111);$A111<>"")