Hiding rows

  • Thread starter Thread starter Glen
  • Start date Start date
G

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to Hide Rows 7
Using Macro to Hide Rows with Certain Values 2
auto hide 8
Excel EXCEL - using a date dependant formula to hide rows 3
Filter/Hide 4
Hide rows with conditional formatting 5
Hide and Show Rows based on Cell Value 2
auto hide blank rows 1

Back
Top