Forum Discussion
Conditional formatting with multiple conditions not working
mtarler thanks for your solution. I had amended my formula to
=AND(ISBLANK(D2),I2="Community ") (yes there is a space after community as it's coming from a drop down selection) and tried it in a dummy column to get a true/false and it worked but when I applied it in the conditional formatting it wasn't working as expected.
On closer inspection there were so many rules already set up that I think it was interfering with the new rule (it's not my spreadsheet). So I cleared out all the rules that weren't doing anything and my conditional formatting is now working 🙂
Thanks for your help.
As a comment
1) As mtarler mentioned it's always better to lock the columns in references, like =AND(ISBLANK($D2),$I2="Community ") even if you apply the rule only to the range in one column, e.g. to A2:A1000.
2) As a rule keep one conditional formatting rule for one color / format applied, avoid using different rules which return the same formatting.