I have a Table (as opposed to a Range) defined in Excel 2010, named
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:
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("RC[-2]",0) )