Fixing Custom Formula Conditional Formatting Highlighting Empty Cells in Red

conditional formattinggoogle sheets

I use the ff. custom formula for conditional formatting in Google sheets: 

=sum(arrayformula(n(regexmatch($J2:$W, "Unsure|Yes")))) = 0

However, it also colors empty cells.

I tried to incorporate the formula as suggested here
but couldn't get it to work either.

If you need to see the sheet I'm using, here's a copy.

Best Answer

An easy way to avoid coloring empty cells is to just check if the cell is empty using isblank(). Replace the formula with

=and(not(isblank(J2)),sum(arrayformula(n(regexmatch($J:$W, "Unsure|Yes")))) = 0)

I've done this for your sheet copy.

Related Topic