'conditional formatting entire row if all cells in that row are empty

I'm trying figure out how to apply style to all rows, but only when entire row is empty, basically if any cell is not empty, the entire row should be skipped. tried =AND(ARRAYFORMULA(ISBLANK(A1:Z))) it doesn't work

Any tips?

arraysgoogle-sheetsformattingconditional-statementstextjoin


Solution 1:[1]

try:

=TEXTJOIN(, 1, $A1:$Z1)=""

enter image description here

skipping one (D) column:

=TEXTJOIN(, 1, $A1:$C1, $E1:$Z1)=""

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1

Related Questions