sort based on color in cell/column

  • Thread starter Thread starter Chris Powers
  • Start date Start date
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
 
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
 
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.
 
Chip - thanks - this looks like just what I needed. Your site could keep me
busy for a while. :-)

-Chris
 
Back
Top