I have a Table (as opposed to a Range) defined in Excel 2010, named Table1
.
The table has blank rows separating groups of 3 to 5 rows with data. Note that not every column in every "non-blank" row contains data. However data exists in column B (named Table1[IdMap]
) for every non-blank row.
I want to format the table (either using Conditional Formatting or static formatting) such that all of the all-blank rows have an off-white background color.
So far I've tried the following Conditional Formatting rules with no luck:
- Select
Table1
(using Ctrl+A while the cell-marquee is in the table) - Conditional Formatting > Rules > New Rule > Use a formula...
- "Format values where this formula is true":
=ISBLANK( $B:$B )
=ISBLANK( INDIRECT("Table1[IdMap]"))
=ISBLANK( INDIRECT("RC[-2]",0) )