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

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
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




"Tom" <Tom@discussions.microsoft.com> wrote in message
news:F8490E49-C06A-4EA3-A380-B4C50BC2F582@microsoft.com...
> 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.

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

"Peo Sjoblom" wrote:

> 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
>
>
>
>
> "Tom" <Tom@discussions.microsoft.com> wrote in message
> news:F8490E49-C06A-4EA3-A380-B4C50BC2F582@microsoft.com...
> > 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.
>
>

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