Sort by color: Is there an easy way to sort columns or rows in EX

[MGP]

Is there an easy way to sort columns or rows in EXCEL by the color of the
text?

 

[Pete_UK]

Take a look at this page on Chip Pearson's site:

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

It shows you how to do it, and there is an example sheet you can
download with all the functions in.

Hope this helps.

Pete

 

[Pete_UK]

Take a look at this page on Chip Pearson's site:

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

It shows you how to do it, and there is an example sheet you can download
with all the functions in.

Hope this helps.

Pete

 

[Bob Phillips]

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

--
HTH

Bob

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

 

[Gord Dibben]

How did the columns and rows get to be colored?

If by Conditional Formatting maybe you can sort on the values that created
the colors?

If manually see Chip Pearson's site for code.

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

CF-colored cells do not respond to the colorindex property so you need
something else.

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


Gord Dibben MS Excel MVP

 

[Bob Phillips]

That should have been
http://xldynamic.com/source/xld.ColourCounter.html#sorting, the # got messed
up

--
HTH

Bob

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