Have a look here
http://www.cpearson.com/excel/SortByColor.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"urnojfk" wrote in message
...
I have been sent a 2000 row report with just the pertinent rows highlighted
by solid color shading (about 300 rows scattered throughout). Is there a
way
to filter down to just those rows that are shaded, or to at least sort to
those rows?