Sorting data that is highlighted with a different color

[Mike]

Does anyone know how you might take a spreadsheet that the
cells have been highlighted with a color and sort the data
based on the color of the highlight

Thanks

 

[Gord Dibben]

Mike

Chip Pearson has info here.....

http://www.cpearson.com/excel/SortByColor.htm

Gord Dibben Excel MVP

 

[Ken Wright]

Try here:-

http://www.cpearson.com/excel/SortByColor.htm