I am trying to hide the whole row if it gives me a zero value.
B Bernard Liengme Nov 15, 2007 #2 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
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
G Gord Dibben Nov 15, 2007 #3 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
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
