vanowm
Reputation: 10221
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?
Upvotes: 1
Views: 878
Answers (1)
player0
Reputation: 1
try:
=TEXTJOIN(, 1, $A1:$Z1)=""
skipping one (D) column:
=TEXTJOIN(, 1, $A1:$C1, $E1:$Z1)=""
Upvotes: 2
Related Questions
- Format entire row if a particular cell in the row is not empty
- Apply conditional formatting only when specified Cell is empty and other conditions are met
- Conditional Formatting: Highlight row except blanks
- Conditional Formatting a cell if it's value matches the value in a specified range
- Google Sheets - Insert text automatically when cell is not empty
- In Google Spreadsheets, how to ignore empty cells in conditional formatting?
- Highlight all cells in a row that are not blank based on value in one cell within row
- conditional formatting entire row if cell contains text
- Apply conditional formatting to whole rows only if multiple rows render true?
- Excel: apply conditional formatting if cell contains one of x strings