Hide and Show Rows based on Cell Value


E

echamp525

I'm creating a sales quote tool for my company and want to hide or
show entire rows based on the value of one cell in a row. I have an
"input sheet" (separate worksheet) that allows the user to specify
whether or not a range of specific products will be included on the
sale quote. On worksheet "Customer Quote" the quantities and sales
price automatically populate through the use of an IF statement. I'd
like excel to auto hide any row in "Customer Quote" when the value is
<=0 and show any row where the value of that specific cell is >=1. I'd
like this code to run each time the values are recalculated as opposed
to having to manually fire the macro each time.

Can someone help me out?

Thanks
 
Ad

Advertisements

D

Don Guillett Excel MVP

I'm creating a sales quote tool for my company and want to hide or
show entire rows based on the value of one cell in a row. I have an
"input sheet" (separate worksheet) that allows the user to specify
whether or not a range of specific products will be included on the
sale quote. On worksheet "Customer Quote" the quantities and sales
price automatically populate through the use of an IF statement. I'd
like excel to auto hide any row in "Customer Quote" when the value is
<=0 and show any row where the value of that specific cell is >=1. I'd
like this code to run each time the values are recalculated as opposed
to having to manually fire the macro each time.

Can someone help me out?

Thanks

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."
 
Ad

Advertisements

E

ed

"If desired, send your file to dguillett  @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."

Use conditional formatting Where cell B-3 is the "conditional cell"
the formula for CF in all other cellsin that row is <=$B$3 and
format the font to the same color as your bockground. You won't see
the input of any cell formatted with this formula when cell B-3 is =
or less than 0, but it will be visable if value is greater than 0.
Repeat for other Rows modifying the formula as indicated.

ed
 

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

Top