software

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.

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

quot;Tomquot; gt; wrote in message
...
gt; How do I create a conditional formula that hides a complete row or rows if
gt; a
gt; value = 0? I want the rows to disappear so that I can print out only the
gt; information for rows that have information in them.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

quot;Peo Sjoblomquot; wrote:

gt; If you are going to use a formula it is not possible to hide, you can use
gt; formatgt;conditional formatting and use white fonts that won't be visible when
gt; printing or you can use a custom format that does not show zeros
gt; However it won't be the same as hiding rows since it will print a blank row,
gt; only other option would be a macro
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Tomquot; gt; wrote in message
gt; ...
gt; gt; How do I create a conditional formula that hides a complete row or rows if
gt; gt; a
gt; gt; value = 0? I want the rows to disappear so that I can print out only the
gt; gt; information for rows that have information in them.
gt;
gt;

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