Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Sort information according to colors in Excel
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/comm...ic.excel.setup |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Sort information according to colors in Excel
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 "Paul" wrote in message ... 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/comm...ic.excel.setup |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Sort information according to colors in Excel
See http://xldynamic.com/source/xld.Colo...r.html#sorting
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Paul" wrote in message ... 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/comm...ic.excel.setup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I data sort multiple sheets in Excel that are linked with i | Excel Worksheet Functions | |||
how to sort date in excel | Excel Worksheet Functions | |||
Sort order : Excel vs imported data | Excel Discussion (Misc queries) | |||
Excel should remember sort criteria | Excel Worksheet Functions | |||
Excel Cell Background Colors Disappeared | Excel Discussion (Misc queries) |