Sort information according to colors in Excel

[Guest]

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.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
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/com...-9602b80be65b&dg=microsoft.public.excel.setup

 

[Paul B]

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

http://www.cpearson.com/excel/SortByColor.htm
--
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

 

[Bob Phillips]

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

--
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
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.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
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/com...-9602b80be65b&dg=microsoft.public.excel.setup