Hi Peter,
Since you want the position of the row to be dependant on the current balance in the bank account, and not what it's balance was last year, or the budget figure, then the ".FormatHidden" command should reference column D only. Then, just present the other colums with their correct sign (debit or credit) as appropriate.
_________________________
Andrew Bates