Any easy way to identify which rows have blank values in specific columns?

**AKM1** · 02-19-2013, 05:38 PM

I have a spreadsheet with columns and columns of data. What I'd like to do is identify which rows have blank/no data in all specified columns (H, K, O, S, U, W, and Y).

To clarify, I need to identify each row where all of these columns are blank (as opposed to each row where at least 1 column is blank).

Is there any easy way to do this?

**Palmetto** · 02-19-2013, 09:09 PM

What do you mean by "identify"?
Do you mean you want the cell address? (Could end up with a long list).

Would using Conditional Formatting to fill blank cells cells with, say, a yellow fill color work for you?
You should lay out your requirements more clearly.

**AKM1** · 02-20-2013, 07:59 AM

I don't need to identify specific cells. Identifying the rows would be enough. Basically, I need to identify every row where those columns I listed are blank.

Conditional formatting might work. But I don't want to highlight every blank cell. Just the rows where each of those columns are blank.

**Palmetto** · 02-20-2013, 08:54 PM

Do you mean:

highlight, say, row-2, if H2, K2, O2, S2, U2, W2, and Y2 are all blank?

Then do the same for, say, row-20 if H20, K20, O20, S20, U20, W20, and Y20 are all blank, and so on down for all rows?

You can still use Conditional formatting with the formula option to highlight entire row

=AND($H2="",$K2="",$O2="",$S2="",$U2v, $W2,$Y2="")

Just select then entire range of cells the open the CF dialog and use the formula.
The formula uses absolute column references so any values in other columns are ignored.

If this isn't what you mean, then upload a workbook and show what you need.