How can i sort data according to the color of the background?

Nate @ GM · Oct 13, 2006

I would like to take the rows of data that i have hilighted and move,
arrange, sort them according to their individual colors. Suggestions?

John Michl · Oct 13, 2006

You'll need a macro to do this. See Chip Pearson's site at
http://www.cpearson.com/excel/SortByColor.htm .

- John Michl
www.JohnMichl.com/exceltips.htm