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

Question

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?

Answer 1

try:

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

skipping one (D) column:

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