Closed Thread
Results 1 to 8 of 8

Sort by Fill Color

  1. #1
    Registered User
    Join Date
    10-24-2013
    Location
    Tulsa
    MS-Off Ver
    Excel 2010
    Posts
    2

    Sort by Fill Color

    I am using excel 2008 and I can not figure out how to sort by fill color. Thanks for the help.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,913

    Re: Sort by Fill Color

    See if this helps

    http://www.datapigtechnologies.com/f...rtonColor.html
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    08-25-2015
    Location
    Irvine
    MS-Off Ver
    2007
    Posts
    5

    Re: Sort by Fill Color

    Hi everyone!

    I'm sure you get asked this often but I can't find what I'm looking for on the internet so I'm asking and yes I'm a new-be! No laughing

    I have a spreadsheet of 9 cells across A4 - I4 (white)and around 900+ down (but will be adding to this number and that's where you all come in...). It'a a list across of company names, legal name, street address, city, state, zip, phone numbers, website and business type. I want to be able to pick a cell like A3 (green) to entering all new info across then click a cell preferably A1 (blue) to be formulated to "Auto Sort" where it will put the row alphabetically down where it below...simple right? I worked off a spreadsheet at my previous job and can work within it, but have no idea how to create one?

    Can you help?

    Nardi
    Screen Shot.jpg

  4. #4
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Sort by Fill Color

    Hi Nardi.

    As with your other post, this one also breaks one of the forum rules..

    2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread. You may include up to 3 links to other URLs in a single post, no more, so only link to the relevant pages.
    Some people would probably argue that this also breaks the duplicate thread rule, but as you didn't start ether of the threads I would be inclined to disagree.

    If you start your own thread in line with rorum rules I'll post a couple of suggestions for you, no doubt some of the other members will have some alternative ideas too.

  5. #5
    Registered User
    Join Date
    08-25-2015
    Location
    Irvine
    MS-Off Ver
    2007
    Posts
    5

    Re: Sort by Fill Color

    I can't figure out where to do that, post? Can you tell me where?

  6. #6
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Sort by Fill Color

    Click on the big 'Excel Forum' logo at the top of the page, then click on 'Excel General' in the forums section.

    There is a button at the top that says 'Start new thread'

  7. #7
    Registered User
    Join Date
    08-25-2015
    Location
    Irvine
    MS-Off Ver
    2007
    Posts
    5

    Re: Sort by Fill Color

    Thank you, I would never have found it on my own!

    Nardi

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,913

    Re: Sort by Fill Color

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] sort by cell fill color
    By trisoldee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2013, 10:43 AM
  2. [SOLVED] Sort by Fill Color
    By Elaine in forum Excel General
    Replies: 7
    Last Post: 01-27-2010, 05:11 AM
  3. [SOLVED] Sort or sub-total by Fill color or font color
    By Excel_seek_help in forum Excel General
    Replies: 1
    Last Post: 04-27-2006, 04:10 PM
  4. How do I sort or count cells by fill color?
    By Rob in forum Excel General
    Replies: 2
    Last Post: 12-23-2005, 05:40 PM
  5. [SOLVED] Excel sort by Fill Color by custom list sort
    By Dash4Cash in forum Excel General
    Replies: 2
    Last Post: 07-29-2005, 06:05 PM

Tags for this Thread

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