| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide sheets based on Cell value | Excel Discussion (Misc queries) | |||
| Automate display/ hide rows in excel based on yes/no check box | Excel Discussion (Misc queries) | |||
| hide rows based on value in cell | Excel Discussion (Misc queries) | |||
| Formula or Macro to hide a row based on a cell value | Excel Discussion (Misc queries) | |||
| Is there a way to HIDE a row based on a value of a cell ? | Excel Discussion (Misc queries) | |||
Linear Mode
