Can I hide rows in Excel 2002 using a formula in a cell?
 

Hello, I would like to know whether it is possible to hide either rows or
columns by writing a command in a cell? Overall, I would like rows and
columns to be created, deleted, or hidden under specific conditions. Is this
possible? If so, how?
Thanks

Can I hide rows in Excel 2002 using a formula in a cell?
 

Not using formulas.

But maybe using macros and worksheet events.

Marc wrote:

Hello, I would like to know whether it is possible to hide either rows or
columns by writing a command in a cell? Overall, I would like rows and
columns to be created, deleted, or hidden under specific conditions. Is this
possible? If so, how?
Thanks

--

Dave Peterson

Can I hide rows in Excel 2002 using a formula in a cell?
 

Thanks Dave

"Dave Peterson" wrote:chrome://ietab/content/reloaded.html?url=

Not using formulas.

But maybe using macros and worksheet events.

Marc wrote:

Hello, I would like to know whether it is possible to hide either rows or
columns by writing a command in a cell? Overall, I would like rows and
columns to be created, deleted, or hidden under specific conditions. Is this
possible? If so, how?
Thanks

--

Dave Peterson

Can I hide rows in Excel 2002 using a formula in a cell?
 

You can change the FORMAT of any cell or groupl of cells by referring
to a formula or condition in other cells with ConditionalFormatting.
You can "hide" the contents of the cells by changing the font color to
white, or the "Pattern" to match the font color, or just Black. You
can apply the formatting to the entire row or column. ed

Can I hide rows in Excel 2002 using a formula in a cell?
 

You can change the FORMAT of any cell or groupl of cells by referring
to a formula or condition in other cells with ConditionalFormatting.
You can "hide" the contents of the cells by changing the font color to
white, or the "Pattern" to match the font color, or just Black. You
can apply the formatting to the entire row or column. ed