I have an Excel spreadsheet with columns, some cells are red, amber, or
green. I need to sort the spreadsheet grouping the colors together.
I have an Excel spreadsheet with columns, some cells are red, amber, or
green. I need to sort the spreadsheet grouping the colors together.
There is a good guide here:
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.
A commercial alternative from yours truly...
http://www.officeletter.com/blink/specialsort.html
--
Jim Cone
San Francisco, USA
"Beth" <[email protected]>
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks