Can I sort columns by colors, example - red, green, yellow

B

Beth

I have an Excel spreadsheet with columns, some cells are red, amber, or
green. I need to sort the spreadsheet grouping the colors together.
 
J

JB

http://cjoint.com/?ftgD2c3vVQ

In module:

Function ColorBack(c As Range)
Application.Volatile
ColorBack = c.Interior.ColorIndex
End Function

In C2: =ColorBack(B2)

A B C
1 Name Salary ColorBack
2 Goutte 4900 6
3 Miroux 4500 6
4 Martin 4000 36
5 Zorba 3200 36
6 Dupont 4000 37
7 Merino 4000 37

Cordialy JB
 
Top