How do I filter or sort by cell shading?
 

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?

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?

Hi Urnojfk,

See Chip Pearson's SortByColor page at::

http://www.cpearson.com/excel/SortByColor.htm

See also Bob Phillips color sorting page at:

http://www.xldynamic.com/source/xld....r.html#sorting


---
Regards,
Norman



"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?