Thread: How do I format excel if cell value is = to 0 then row height = 0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jane11804
 
Posts: n/a
Default How do I format excel if cell value is = to 0 then row height = 0
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




Reply With QuoteReply With Quote