CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
alittlecurryhot
alittlecurryhot

Reputation: 487

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

Upvotes: 0

Views: 31

Answers (1)

rockinfreakshow
rockinfreakshow

Reputation: 29982

You may try this custom formula within CF

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

Upvotes: 1

Related Questions