software

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

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) ...
www.officeletter.com/blink/specialsort.html

Jim Cone
San Francisco, USA
www.realezsites.com/bus/primitivesoftware
quot;talkCGquot; gt;
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

Hi talkCGquot; ,
Or you can write your own macro, code available at
Sorting by Color
www.cpearson.com/excel/SortByColor.htm

Conditional Formatting colors is a bit more complicated, see
reference at the bottom of that page. But you should use the same
formula that you used to get C.F. and avoid that problem.

Needless to say sorting on color is not a good idea, as Jim indicated
Excel 2007 (Excel 12) will support color better. Currently if you change
color it will not trip an Event so you have to perform a manual calculation,
force a calculation, or use volatile.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Jim Conequot; gt; wrote in message ...
gt; VBA code is required to sort by color.
gt; The next release of Excel will sort by color - availability is still uncertain.
gt; Here is info on a commercial Excel add-in that sorts by color (from yours truly) ...
gt; www.officeletter.com/blink/specialsort.html
gt;
gt; Jim Cone
gt; San Francisco, USA
gt; www.realezsites.com/bus/primitivesoftware
gt;
gt;
gt;
gt; quot;talkCGquot; gt;
gt; wrote in message
gt; ...
gt; Is there a way to Sort a Spreadsheet by Color? I have an enormous spreadsheet
gt; with yellow highlights scattered through and I want to sort by the
gt; Highlighted rows.
gt; How do I do this?
gt; thank you