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


>Solution :

You may try this custom formula within CF


Leave a Reply