![]() |
Excel should let me sort by colour
As an Accountant I generally highlight figures in different colours when
carrying out reconciliations. It would be useful if you could use the Excel sort function to sort by colour. For Example: It could allow you to sort by Red, then blue, then green ---------------- 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...et.f unctions |
kbatey25 Wrote: As an Accountant I generally highlight figures in different colours when carrying out reconciliations. It would be useful if you could use the Excel sort function to sort by colour. For Example: It could allow you to sort by Red, then blue, then green ---------------- 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://tinyurl.com/bubtl Hi kbatey25 This may help you http://www.cpearson.com/excel/SortByColor.htm -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=466197 |
All times are GMT +1. The time now is 11:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com