please introduce sorting by colors in excel

[Guest]

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/com...e-84151e3ddddb&dg=microsoft.public.excel.misc

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

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/com...e-84151e3ddddb&dg=microsoft.public.excel.misc

 

[SteveW]

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

 

[Guest]

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