View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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