please introduce sorting by colors in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
See http://xldynamic.com/source/xld.ColourCounter.html#sorting

--
HTH

Bob Phillips

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

DCDK said:
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.
Click to expand...
http://www.microsoft.com/office/com...e-84151e3ddddb&dg=microsoft.public.excel.misc
 
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
 
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
 
Back
Top