Sort information according to colors in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul - 25 Aug 2006 09:26 GMT

A lot of information in Excel often has to be colored in different colors in
order to differ and comprehend this information easily. It could be both
background and letter colors. Sometimes it could be hundreds of lines and
tens of columns. It would be really helpful if Excel would recognize the
colors, search for them, understand the difference and sort the info
according to them.

Reply to this Message

Paul B - 25 Aug 2006 16:22 GMT

Paul, have a look here for a way to do it,

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

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

>A lot of information in Excel often has to be colored in different colors
>in
[quoted text clipped - 13 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=b4ae3c63-6e20-4
f3f-96b4-9602b80be65b&dg=microsoft.public.excel.setup

Reply to this Message

Bob Phillips - 26 Aug 2006 09:50 GMT

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

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> A lot of information in Excel often has to be colored in different colors in
> order to differ and comprehend this information easily. It could be both
[quoted text clipped - 9 lines]
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.

http://www.microsoft.com/office/community/en-us/default.mspx?mid=b4ae3c63-6e20-4
f3f-96b4-9602b80be65b&dg=microsoft.public.excel.setup

Reply to this Message

Rate this thread: