View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Giggly4g Giggly4g is offline
external usenet poster
 
Posts: 21
Default locate positive numbers and delete rows containing

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.