VBA code is required to sort by color.
The next release of Excel will sort by color - availability is still uncertain.
Here is info on a commercial Excel add-in that sorts by color (from yours truly) ...
http://www.officeletter.com/blink/specialsort.html

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"talkCG"
wrote in message
...
Is there a way to Sort a Spreadsheet by Color? I have an enormous spreadsheet
with yellow highlights scattered through and I want to sort by the
Highlighted rows.
How do I do this?
thank you