MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Find Blank cells in 1 col. then format the row


Posted by John S. on January 26, 2001 11:54 AM

How can I after finding the blank cells in one column format the entire row a certain color


Posted by Mark W. on January 26, 2001 11:58 AM

John, did you consider using conditional formatting?

Posted by Mark W. on January 26, 2001 12:03 PM

For example, select 1:1, choose the Format Conditional
Formatting... menu command, apply a "Formula Is"
condition with =ISBLANK($A1) as the formula.

Posted by John S. on January 26, 2001 12:19 PM

Well yeah! but I thought there would be an easier way. thanks though

Posted by John S. on January 26, 2001 12:20 PM

Posted by John S. on January 26, 2001 12:21 PM

When doing subtotals. I want the whole subtotal row grey

Posted by John S. on January 26, 2001 12:26 PM

I got it.