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.
