ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to delete excel cells that are color-filled? (https://www.excelbanter.com/excel-programming/300025-how-delete-excel-cells-color-filled.html)

Mikrolet

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.


All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com