Excel sort by Fill Color by custom list sort
 

I would like to be able to highlight data different colors and then use the
sort feature to group the alike colors together. I know you can add a column
and make numbers and sort by that. But it would be nice to be able to make a
custom list sort with different color fills and have them group them together.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

This is not a wise thing to do. But if you insist see
SortByColor
http://www.cpearson.com/excel/SortByColor.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dash4Cash" wrote
I would like to be able to highlight data different colors and then use the
sort feature to group the alike colors together. I know you can add a column
and make numbers and sort by that. But it would be nice to be able to make a
custom list sort with different color fills and have them group them together.

Hi Dash4Cash wrote:
I would like to be able to highlight data different colors and then
use the sort feature to group the alike colors together.

have also a look there :
http://www.ozgrid.com/VBA/Sort.htm

HTH