Excel should let me sort on cell background color

[Guest]

Version excel 2003

 

[Nick Hodge]

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)

 

[Gord Dibben]

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

 

[Jack in the UK]

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

 

[Guest]

The cell where I put the function say #Name?. In detail, where do I copy in
the UDF? Tool - Macro - VBA - ? - ? - ?

 

[Dave Peterson]

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