View Single Post
  #2   Report Post  
Huw Davies
 
Posts: n/a
Default

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.