View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mikrolet Mikrolet is offline
external usenet poster
 
Posts: 1
Default how to delete excel cells that are color-filled?

I have a spreadsheet where some cells are color-filled. I am trying to
delete the cells that are color-filled with green and leave those that
are not color-filled. The problem is, the color-filled cells are
scattered all over the 60k-row spreadsheet and manually deleting them
is a pain.

Does anybody have any idea how to do this quickly? Any macros would be
appreciated.

Thanks.