Excel: Deleting rows using interior color.index value


I would like code to delete all rows where the cell fill interior color.index values in column B is not 3. This would leave just the rows with red formatted cells (interior color.index = 3) in column B. Is this possible? Many thanks Chad


This question generated 9 answers. To proceed to the answers, click here.

This thread is current as of May 03, 2015.


For more resources for Microsoft Excel