N Nick Hodge Jan 8, 2005 #2 Mama It's not standard functionality but you could put a UDF (User Defined Function) in the workbook and then enter it in another column and sort by that. =ReturnColorIndex(A1) UDF (Place in a standard module in the workbook) Function ReturnColorIndex(rCell As Range) As Integer Application.Volatile True ReturnColorIndex = rCell.Interior.ColorIndex End Function -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed)
Mama It's not standard functionality but you could put a UDF (User Defined Function) in the workbook and then enter it in another column and sort by that. =ReturnColorIndex(A1) UDF (Place in a standard module in the workbook) Function ReturnColorIndex(rCell As Range) As Integer Application.Volatile True ReturnColorIndex = rCell.Interior.ColorIndex End Function -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed)
G Gord Dibben Jan 8, 2005 #3 mama http://register.microsoft.com/mswish/suggestion.asp While waiting for MS to make the changes in the next version you should visit Chip Pearson's site to see what's available for working with colors. http://www.cpearson.com/excel/SortByColor.htm Gord Dibben Excel MVP
mama http://register.microsoft.com/mswish/suggestion.asp While waiting for MS to make the changes in the next version you should visit Chip Pearson's site to see what's available for working with colors. http://www.cpearson.com/excel/SortByColor.htm Gord Dibben Excel MVP
J Jack in the UK Jan 13, 2005 #4 My great friend Dave Hawley www.OzGrid.com has some dowmloadable example in XLS format sure you find something there, and VBA code is open source too. Jack
My great friend Dave Hawley www.OzGrid.com has some dowmloadable example in XLS format sure you find something there, and VBA code is open source too. Jack
G Guest Jul 5, 2006 #5 The cell where I put the function say #Name?. In detail, where do I copy in the UDF? Tool - Macro - VBA - ? - ? - ?
The cell where I put the function say #Name?. In detail, where do I copy in the UDF? Tool - Macro - VBA - ? - ? - ?
D Dave Peterson Jul 5, 2006 #6 The code goes in a general module inside that workbook's project (in the VBE). If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm
The code goes in a general module inside that workbook's project (in the VBE). If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm
