How do I create a conditional formula that hides a complete row o.

T

Tom

How do I create a conditional formula that hides a complete row or rows if a
value = 0? I want the rows to disappear so that I can print out only the
information for rows that have information in them.
 
P

Peo Sjoblom

If you are going to use a formula it is not possible to hide, you can use
format>conditional formatting and use white fonts that won't be visible when
printing or you can use a custom format that does not show zeros
However it won't be the same as hiding rows since it will print a blank row,
only other option would be a macro

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 
T

Tom

Thanks, Peo. Not the answer that I wanted to hear, but the correct answer
probably none the less.

If anyone else comes up with a solution, it would be great to hear.

Thanks, again.

Tom
 
P

Pete_UK

Apply a filter to the column which contains your values which might
equal 0. To hide the rows, choose Custom Filter | Not Equal To 0
(zero). Then you can print out.

Hope this helps.

Pete
 
Top