Is there a formula to hide/ display row based on cell value in Exc
 

Excel 2003.

Is there a formula to hide or display a row/column based on the value of
another cell?

Is there a formula to hide/ display row based on cell value in Exc
 

Rick,

An Excel formula can only place a value in the cell in which it is written;
it cannot perform functions such as hiding or deleting rows. You would need
to resort to code for that.

Mike

"RickA" wrote:

Excel 2003.

Is there a formula to hide or display a row/column based on the value of
another cell?

Is there a formula to hide/ display row based on cell value in Exc
 

Formulas cannot do anything other than return a result to the cell in which they
are written.

To hide rows/columns based upon a value would reuire VBA, probably event code.

You could use Conditional Formatting to hide a cell's contents by setting font
color same as background color based on another cell's value.


Gord Dibben MS Excel MVP

On Fri, 14 Sep 2007 01:22:02 -0700, RickA
wrote:

Excel 2003.

Is there a formula to hide or display a row/column based on the value of
another cell?