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?