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