Sorting in Excel

[Boondy]

Does anyone know how to sort rows by colour in Excel? IS this possible?

For example I have 100 rows , 30 with black text, 30 with blue and 40 with red, all in random order. I want the spreadsheet to have all the blue at the top, then all the red, followed by all the black.

 

[PeterMoran]

Hi EmadT,

Checkout Chip Pearson's site at:

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

and then mark it in your Favorites as a top Excel reference.

Good Luck!
Peter Moran

 

[substitute]

You can probably skip the VBA by rotating the problem. Why are the rows black, red or blue? Is it to do with some data in the row?

If you can write a formula that returns 1 if the row should be blue, 2 if it should be red and 3 if it should be black you can use conditional formatting to colour the row according to the result of the formula. Sorting on the column containing the formula gives you the desired result without any VBA.

This won't work if you have more than 4 colours, you can only have 3 conditional formats plus the original format.