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

G

Guest

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

(e-mail address removed)
 
G

Guest

Hi

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

Andy.
 
I

Infinity

With condition formatting it is not possible as condition formattin
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 thi
forum.

Rgds
 
G

Guest

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

Jane11804
 
G

Guest

Thanks for the feedback!

Andy.

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

Jane11804
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I autofit row height to adjust to new text on Excel form? 1
Make row white unless the value of a certain cell is >0 6
if cell = 0 then hide the row? 9
How to copy rows from Excel without losing the row height format 1
How to change default row height 0
Are there limits autofit row height when the cell is set to wrap t 3
Conditional format lowest value greater than zero and copy formula 2
Data Entry Form - Execute if value is not 0 5

Top