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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel 2003.

Is there a formula to hide or display a row/column based on the value of
another cell?
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide columns based on row values 2
Help needed 0
Excel VBA 1
Creating a function to auto hide rows 1
Hiding sum formula answers in select cells 5
Excel EXCEL - using a date dependant formula to hide rows 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Hiding Formula Answers in Specific Cells 1

Back
Top