Excel 2003. Is there a formula to hide or display a row/column based on the value of another cell?
R RickA Sep 14, 2007 #1 Excel 2003. Is there a formula to hide or display a row/column based on the value of another cell?
M Mike H Sep 14, 2007 #2 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
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
G Gord Dibben Sep 14, 2007 #3 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
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
