Google-sheets – Format cell if all the cells in a row are not empty

conditional formattingformulasgoogle sheetsgoogle-sheets-arrayformulagoogle-sheets-query

I tried all kind of formula but they all seem to work the other way around for me. I have a very large sheet with lots of columns. I'd like to have the first cell in the row to be a certain color if any of the cells in that row is empty. Basically, a warning saying not all the cells have value.

The first step, I'm trying to make it work just for one row for now and I'm stuck.
Let say for row 2, format cell A2 in red if any of the cells in the range is empty. I tried

=len(join("", B2:ZZ2))

=$B2=""

=NOT(ISBLANK(B2:ZZ2))

It's not working! It's getting red even if only one cell as something in it.

Best Answer

Actually I found a very simple answer. =COUNTBLANK() and it's working.

Thanks anyway

Related Solutions

Google Sheets Query for Non-Empty Cells

Please try:

=QUERY('Form Responses 1'!A:N,"SELECT C,E,G,H where G is not null or H is not null order by C,E")

Google-sheets – Format a cell in bold if its row has other nonempty cells

You don't need a script for that; the built-in conditional formatting tools are flexible enough. Assuming the first row is for headers, apply conditional formatting to the range A2:A, with custom formula =len(join("", B2:Z2)). This means: join the content of cells, and find its length; the formatting applies if the length is greater than 0.

Replace Z by AZ or something else if you have more columns. (The formula will automatically adjust if you insert more columns between A and Z later.)

Bold formatting is found in the formatting dropdown, select "Custom" as below.

example

Best Answer

Related Solutions

Google Sheets Query for Non-Empty Cells

Google-sheets – Format a cell in bold if its row has other nonempty cells

Related Topic