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

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

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

There is a good guide he
http://www.cpearson.com/excel/SortByColor.htm

Hope this helps,
Miguel.

"Beth" wrote:

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

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

A commercial alternative from yours truly...
http://www.officeletter.com/blink/specialsort.html
--
Jim Cone
San Francisco, USA


"Beth"
wrote in message
I have an Excel spreadsheet with columns, some cells are red, amber, or
green. I need to sort the spreadsheet grouping the colors together.

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

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