Delete all Highlighted Rows

[Guest]

I need to delete all rows in my worksheet that are not highlighted. With the
worksheet I have rows highlighted in gray, yellow, pink, etc. I need to
delete all rows that are not highlighted - anyone have a suggestion?

 

[Frank Kabel]

Hi
first you need a helper column showing the color indey of these rows.
See:
http://www.cpearson.com/excel/colors.htm

Afterwards you can filter with this column and delete the filtered rows