Conditional formatting is not working if all in the selected range are blank

I trying to apply conditional formatting on selected cells (A2:C2) with condition that if all aren’t filled all selected cells must be in color red, once they all are filled then the color should be white.

I am using Google sheets, formula used is

formatting

>Solution :

You may try this custom formula within CF

=COLUMNS($A2:$C2)-COUNTBLANK($A2:$C2)<>COLUMNS($A2:$C2)

Leave a Reply