I don't think you can use conditional format to automatically hide rows that
are blank. It's either do it by eye using the "hide" option under Format |
Row menu, or by using VBA.
Huw.
"tamato43" wrote:
Hello All,
Does anyone know how to set a conditional format to hide a colum and/or row
if they are left blank?
Example:
I have a spreadsheet that imports info from another worksheet or file into
10 rows.
In some cases I only populate rows 1 through 5 leaving 6 through 10 blank,
So I'd like to hide those rows.
Please help.
|