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

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?

CodePudding user response：

try:

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

skipping one (D) column:

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

CodePudding user response：

You can use custom formula in conditional formatting.

Select the range where you want to apple the formatting e.g. A1:Z.
Now open conditional formatting tab, and Custom formula is.
add this formula =and(ArrayFormula(ISBLANK($A1:$Z1)))
Apply formatting and save it.

Reference:-

Conditional Formatting