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

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Kamani" wrote in message
...
I am trying to hide the whole row if it gives me a zero value.

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


On Thu, 15 Nov 2007 09:38:06 -0800, Kamani
wrote:

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