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

M

Marc

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
 
E

edcosoft

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
 
E

edcosoft

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
 
Top