Hiding rows

[Glen]

Hi,

Wondering if there is a way to hide a row depending on the value of a
certain cell.
eg. if any cells in column C has "xxx" then hide entire row.
I'm guessing there is a way to do it using logic or conditional formats but
not sure what to use to hide the row.

 

[David Biddulph]

Use Auto-filter

 

[Gord Dibben]

Formulas cannot hide rows or cells.

CF can change font to white.

To actually hide the row(s) you need autofilter or VBA


Gord Dibben MS Excel MVP