sort based on color in cell/column

C

Chris Powers

Is there a way to do a sort based on the color of the column?

For example, I want red grouped together, then blue, then green. In theory,
I'd think so as color would be some property of a cell that I'd think I
could access, but I don't know...

thanks,
Chris
 
G

GJones

Chris;

If you are using Excel XP there is an "Options" button and
Formatting choice when you do a sort that let you do
exactly what your are asking for. I do not believe it is
in the earlier versions.

Thanks,

Greg
 
E

EdgeOfCity

Maybe u can use Macro 4 function such as get.cell(24,range) to do this.
or use VBA code to get the color index and then sort by colorindex.
 
C

Chris Powers

Chip - thanks - this looks like just what I needed. Your site could keep me
busy for a while. :)

-Chris
 
Top