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
-----Original Message-----
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,

See http://www.cpearson.com/excel/SortByColor.htm for example code to sort
by color.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chris Powers" wrote in message
...
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

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

-Chris
"Chip Pearson" wrote in message
...
Chris,

See http://www.cpearson.com/excel/SortByColor.htm for example code to sort
by color.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chris Powers" wrote in message
...
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