Your best bet would be filtering. Use DataFilterAdvanced Filter records
greater than zero. Now you have all the positive rows displayed, and you can
delete them all. Turn off the filter and you're left with only the negative
records.

Note that it will take a while to delete the filtered records if you have a
lot of them.

Regards,
Fred.

"Giggly4g" wrote in message
...
I'm trying to isolate negative balances in a very large wookbook. Is there
a
way to easily locate the positive balances and delete the rows containing
them (leaving only the negative balances)? I've tried to mark with
conditional formatting for 0 but the column titles get marked, too. Any
assistance would be greatly appreciated.