adding zero and deleting rows

[Diana2013]

I have attached a file that I need help with. The cells that are blank need to have "0" in them. Then any row that does have a value should be hidden. What is the best way to do this. I have tried a IF statement but can not make it work.

Thanks
Diana

[LaffyAffy13]

You can't conditionally format cell rows or columns to be hidden (AFAIK). You can, however, use the sheet with data on it as a place to grab the information from. Instead of hiding the rows, you could try (in a different sheet) only taking the rows that you want, according to their contents. Does that make sense?

[Pepe Le Mokko]

Your title states "delete" and the text "hide" rows??

[Diana2013]

Yes I did and I do not know how to change it now.

[LaffyAffy13]

Change what? What did you do?

[Diana2013]

Sorry wrong person - one reply said my title was wrong. Should have been "hide" not "delete"

[LaffyAffy13]

Well, regardless, you cannot hide rows the way you are describing, AFAIK