Hide the zero values in a work book

[Guest]

I am trying to hide the whole row if it gives me a zero value.

 

[Bernard Liengme]

You could use conditional formatting to change the font colour to the same
colour as the cell background if a certain cell in the row evaluates to
zero.
best wishes

 

[Gord Dibben]

Rows can be hidden manually or by VBA but not by formulas or Formatting.

You can make the cells look blank by using CF as Bernard points out.

Or try Autofilter to show only rows with no zero in a particular cell.


Gord Dibben MS Excel MVP