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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RickA - 14 Sep 2007 09:22 GMT

Excel 2003.

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

Reply to this Message

Mike H - 14 Sep 2007 09:26 GMT

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

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

Reply to this Message

Gord Dibben - 14 Sep 2007 21:33 GMT

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

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

Reply to this Message