ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   please introduce sorting by colors in excel (https://www.excelbanter.com/excel-discussion-misc-queries/112584-please-introduce-sorting-colors-excel.html)

DCDK

please introduce sorting by colors in excel
 
I'm uncertain as to if it's office 2007, but can i sort by colour. If not can
it be introduced. It would make my organisational structuring much easier to
manage.

thanks

----------------
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...lic.excel.misc

Bob Phillips

please introduce sorting by 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)

"DCDK" wrote in message
...
I'm uncertain as to if it's office 2007, but can i sort by colour. If not

can
it be introduced. It would make my organisational structuring much easier

to
manage.

thanks

----------------
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...lic.excel.misc



SteveW

please introduce sorting by colors in excel
 
I've not used Discussions.microsoft.com as a method of posting here

But why do we get so many duplicate or triplicate postings

Steve

On Tue, 03 Oct 2006 11:09:01 +0100, DCDK
wrote:

I'm uncertain as to if it's office 2007, but can i sort by colour. If
not can
it be introduced. It would make my organisational structuring much
easier to
manage.

thanks

----------------
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...lic.excel.misc




--
Steve (3)

Dave F

please introduce sorting by colors in excel
 
You can sort by color by creating user defined functions in VBA. I think the
other responders to this post have provided a link to a set of very clear
instructions on how to do this.

Dave
--
Brevity is the soul of wit.


"DCDK" wrote:

I'm uncertain as to if it's office 2007, but can i sort by colour. If not can
it be introduced. It would make my organisational structuring much easier to
manage.

thanks

----------------
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...lic.excel.misc



All times are GMT +1. The time now is 08:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com