Hi, i am trying to sort data that has been identify by colors. Can it be done?
can i sort data by color ?
thank you for your attention.

I assume that you are wanting to use conditional formatting for this little
endeavor.

However, as far a I know there is currently no way to sort it as such.
Sorry if this wasn't the answer you were looking for.

Just so I know, are you coloring them through conditional formatting or are
you just changing the color manually?
--
Learning without thought is labor lost.

Thought without learning is perilous.


"Joseph" wrote:

Hi, i am trying to sort data that has been identify by colors. Can it be done?
can i sort data by color ?
thank you for your attention.

Hi Joseph

Chip Pearson has a section on this:

http://www.cpearson.com/Excel/SortByColor.aspx

"Joseph" wrote:

Hi, i am trying to sort data that has been identify by colors. Can it be done?
can i sort data by color ?
thank you for your attention.

One problem I can see with this option, and that is if this spreadsheet is
meant to be distributed. If you intend to distribute this among computers,
each will be required to have this item.
--
Learning without thought is labor lost.

Thought without learning is perilous.


"PJ" wrote:

Hi Joseph

Chip Pearson has a section on this:

http://www.cpearson.com/Excel/SortByColor.aspx

"Joseph" wrote:

Hi, i am trying to sort data that has been identify by colors. Can it be done?
can i sort data by color ?
thank you for your attention.

The code is within a module in the workbook so will be distributed with the
workbook.

I don't see a problem.


Gord Dibben MS Excel MVP

On Tue, 21 Apr 2009 06:18:06 -0700, Benji
wrote:

One problem I can see with this option, and that is if this spreadsheet is
meant to be distributed. If you intend to distribute this among computers,
each will be required to have this item.