+ Reply to Thread
Results 1 to 3 of 3

Excel sort by Fill Color by custom list sort

  1. #1
    Dash4Cash
    Guest

    Excel sort by Fill Color by custom list sort

    I would like to be able to highlight data different colors and then use the
    sort feature to group the alike colors together. I know you can add a column
    and make numbers and sort by that. But it would be nice to be able to make a
    custom list sort with different color fills and have them group them together.

    ----------------
    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

  2. #2
    David McRitchie
    Guest

    Re: Excel sort by Fill Color by custom list sort

    This is not a wise thing to do. But if you insist see
    SortByColor
    http://www.cpearson.com/excel/SortByColor.htm

    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "Dash4Cash" <[email protected]> wrote
    > I would like to be able to highlight data different colors and then use the
    > sort feature to group the alike colors together. I know you can add a column
    > and make numbers and sort by that. But it would be nice to be able to make a
    > custom list sort with different color fills and have them group them together.




  3. #3
    Modeste
    Guest

    Re: Excel sort by Fill Color by custom list sort

    Hi Dash4Cash wrote:
    > I would like to be able to highlight data different colors and then
    > use the sort feature to group the alike colors together.


    have also a look there :
    http://www.ozgrid.com/VBA/Sort.htm

    HTH





+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1