Selecting Rows based off certain criteria and deleting all others

[Jonathan]

Hi all,

I have a large population of data that needs to be sorted by certain
criteria, and I'm not all too great with macros, so if anyone could please
assist, that'd be great.

All I need to do for right now is remove all the rows that have no
highlighting in any of the columns. I've already gone through and
auto-filtered certain values that need to be analyzed, but there are
thousands of rows that didn't meet any of the criteria, so I'd like to remove
them. Is there a simple macro I can run that will search all 7 columns of
each row, and if none of them are highlighted, they will be deleted?

Thanks,

Jonathan

 

[Jonathan]

Also, if possible, I'd like to add a function where, for each row that has a
highlight, creating a new column and saying what the top row (column name) is
so I can see which row is being pulled for what column being highlighted.
(Example, if Rules 3 and 4 are the ones highlighted, it would create a new
column that would say "3,4"