If you are going to use a formula it is not possible to hide, you can use
formatconditional 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




"Tom" wrote in message
...
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.