Sort columns by color

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BZeyger - 25 Sep 2007 18:18 GMT

I am using an excell document that has various color cells in different
columns. Is there a way to sort these colums by color?

Reply to this Message

Matthew Pfluger - 25 Sep 2007 18:26 GMT

If you want something quick, consider ASAP Utilities. The free add-in
contains a very powerful Advanced Sorting Macro. See www.asap-utilities.com.

HTH,
Matthew Pfluger

> I am using an excell document that has various color cells in different
> columns. Is there a way to sort these colums by color?

Reply to this Message

Gord Dibben - 25 Sep 2007 18:32 GMT

See Chip Pearson's site for sorting with colors.

http://www.cpearson.com/excel/SortByColor.htm

Gord Dibben MS Excel MVP

>I am using an excell document that has various color cells in different
>columns. Is there a way to sort these colums by color?

Reply to this Message

Bob Phillips - 25 Sep 2007 18:35 GMT

See http://xldynamic.com/source/xld.ColourCounter.html#sorting

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I am using an excell document that has various color cells in different
> columns. Is there a way to sort these colums by color?

Reply to this Message