How do I filter or sort by cell shading?

[Guest]

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?

 

[Paul B]

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

 

[Norman Jones]

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.ColourCounter.html#sorting