Logic Statement to Hide Rows?

[gordco]

Hi,
I need to create logic, that will hide a changing number of contiguous rows that have a negative balance. My defined print area needs to remain the same, which includes a table of values, followed by a text box. In the example I included, as the user changes the Factor in B1, the Balance will change. Starting at the row where the Balance goes negative, I need to hide all the rows that follow with a negative balance. I need this to be done automatically through a logic statement ("IF" statement??).

Thanking anyone that can help with this perplexing problem.
Gordco

[fullysic]

Hi gordco,

One way you could achieve what you are after is to use conditional formatting. Assuming the balance is always sorted highest to lowest I don't forsee any issues.

See attached workbook for an example.

fullysic

[gordco]

Hi gordco,

One way you could achieve what you are after is to use conditional formatting. Assuming the balance is always sorted highest to lowest I don't forsee any issues.

See attached workbook for an example.

fullysic

Thanks for the suggestion. The only problem remaining is defining the print area. If the code covers 3 pages, but value drop below zero on page 1, the conditional formatting only shows values on page 1 (that's good). But the print command prints pages 2 and 3 also, which are blank. I could manually define the print area each time, but I hope to find a way to do this automatically. In other words, only print that which is visible.
Thanks

[bstubbs]

Can you not use autoFilters to limit the data to be printed to only non-zero data? That should solve your blank page problem.

HTH.

Bob