Conditional format to shade/color every blank row?

[Nick]

Just as the title says. Thanks.

 

[ShaneDevenshire]

Hi Nick,

The answer depends on the version of Excel you are using:

2003 or earlier - Highlight all rows you are interested in by dragging
through the row numbers. Let's assume you highlight from row 1 down to row
28, starting in row 1.
Choose Format, Conditional Formatting, and choose Formula is from the first
drop down.
In the next box enter the formula =COUNTA(1:1)=0
Click Format and set whatever you want.

 

[Nick]

I enter that and it shaded some rows but not all. I have a huge spreadsheet
with colored rows as spacers that has crashed and keeps crashing and retains
values on recover but loses formatting. Since the entire row of the spacer
rows are blank I just want to find a faster way to shade them without using
the format painter. Any other ideas?

 

[ShaneDevenshire]

Hi Nick,

My suggestion above does it all in one simple set of steps!
1. Highlight all the row numbers down as far as you want.
2. Use Conditional Formatting exactly like I described.
3. When you click OK all rows that are completely blank will be formatted
with the color you choose and all non-blank rows will remain unformatted.