Hi all,

I’ve created a budget where I’m comparing actual numbers to budgeted numbers. I want to hide rows if the cell reveals a zero value. These cells are all formulae based (drawing data from another worksheet).

So for example, if the formulae in column O and P results in a value of 0, I want that corresponding row to be hidden (and unhidden if not equal to 0). Any ideas on how I can do this?

And I don't want blank rows hidden, just ones with a 0 value.

Thanks for any input,