How do I format excel if cell value is = to 0 then row height = 0

[Jane11804]

I have one mail worksheet with all of my data on it, then four other sheets
containing "if" formulas to split the main data into sections. To make this
easily printable, I think I need a conditional format to hide the rows with
no data in; ie IF D4=0, ROW HEIGHT=0, ROW HEIGHT=20

Is this possible?

Thanks in advance

jane11804@hotmail.com

[Infinity]

With condition formatting it is not possible as condition formatting only does formatting. I believe tha only way to do it via a macro. Maybe you could ask this question in the programming section of this forum.

Rgds.

Hi

You should have a look at Data/Filter/Autofilter. I think it might be what
are wanting.

Andy.

"Jane11804" <Jane11804@discussions.microsoft.com> wrote in message
news:FB183C6E-BCBA-4BAC-A5EE-EA112C7D619C@microsoft.com...
>I have one mail worksheet with all of my data on it, then four other sheets
> containing "if" formulas to split the main data into sections. To make
> this
> easily printable, I think I need a conditional format to hide the rows
> with
> no data in; ie IF D4=0, ROW HEIGHT=0, ROW HEIGHT=20
>
> Is this possible?
>
> Thanks in advance
>
> jane11804@hotmail.com
>
>

[Jane11804]

many thanks Andy for your very prompt reply; yes this does excatly what I
wanted it to do. Many thanks again

Jane11804

"Andy" wrote:

> Hi
>
> You should have a look at Data/Filter/Autofilter. I think it might be what
> are wanting.
>
> Andy.
>
> "Jane11804" <Jane11804@discussions.microsoft.com> wrote in message
> news:FB183C6E-BCBA-4BAC-A5EE-EA112C7D619C@microsoft.com...
> >I have one mail worksheet with all of my data on it, then four other sheets
> > containing "if" formulas to split the main data into sections. To make
> > this
> > easily printable, I think I need a conditional format to hide the rows
> > with
> > no data in; ie IF D4=0, ROW HEIGHT=0, ROW HEIGHT=20
> >
> > Is this possible?
> >
> > Thanks in advance
> >
> > jane11804@hotmail.com
> >
> >
>
>
>

Thanks for the feedback!

Andy.

"Jane11804" <Jane11804@discussions.microsoft.com> wrote in message
news:45E1414A-F635-457E-832F-9C74312A5DC9@microsoft.com...
> many thanks Andy for your very prompt reply; yes this does excatly what I
> wanted it to do. Many thanks again
>
> Jane11804
>
> "Andy" wrote:
>
>> Hi
>>
>> You should have a look at Data/Filter/Autofilter. I think it might be
>> what
>> are wanting.
>>
>> Andy.
>>
>> "Jane11804" <Jane11804@discussions.microsoft.com> wrote in message
>> news:FB183C6E-BCBA-4BAC-A5EE-EA112C7D619C@microsoft.com...
>> >I have one mail worksheet with all of my data on it, then four other
>> >sheets
>> > containing "if" formulas to split the main data into sections. To make
>> > this
>> > easily printable, I think I need a conditional format to hide the rows
>> > with
>> > no data in; ie IF D4=0, ROW HEIGHT=0, ROW HEIGHT=20
>> >
>> > Is this possible?
>> >
>> > Thanks in advance
>> >
>> > jane11804@hotmail.com
>> >
>> >
>>
>>
>>