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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can i sort data according to the color of the background? (https://www.excelbanter.com/excel-worksheet-functions/114314-how-can-i-sort-data-according-color-background.html)

Nate @ GM

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

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

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

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

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

All times are GMT +1. The time now is 01:36 PM.