Excel: Sort by cell color


Note: Applicable to Excel 2007 or later

Scenario: I have a spreadsheet of checks issued for the year. For each check, I need to determine if the disbursement was made for a fixed asset or not. As I go through each item and view the invoice, I shade the amount cell either green (fixed asset), yellow (missing invoice or question), or red (not a fixed asset).

For example:

SS-2011.05.17-13.52.39

After I have gone through this list, it would be nice to be able to sort by the colors I used. I know there are a thousand and one ways to accomplish this task without the use of colors, but I am a very visual person. The colors give me a good picture of the results of my work.

Solution:

  1. Select the region to sort.
  2. On the Data ribbon, select “Sort.”
    SS-2011.05.17-13.57.24
  3. Choose the amount column (or whichever column contains the color-coding) to sort by.
  4. Choose Cell Color to sort on.
  5. Select the color you would like on top.
  6. Add additional lines to specify the order of the remaining colors.
  7. Click OK to complete the sort.

My sort window looks like this:

Sort-2011.05.17-13.59.57

The result looks like this:

SS-2011.05.17-14.01.00

Advertisements
  1. #1 by http://thedesignstudioinc.weebly.com/ on February 8, 2013 - 7:25 pm

    Thanks for your time for posting “Excel:
    Sort by cell color CPA Tech Tips”. Imay absolutely end
    up being coming back for alot more reading and writing comments soon.
    With thanks, Brooke

  2. #2 by www.draadloos.org on April 19, 2013 - 4:28 pm

    The following blog, “Excel: Sort by cell color | CPA Tech Tips” demonstrates the fact that u really know just
    what you are communicating about! I fully agree with your
    post. Thanks a lot -Wade

  3. #3 by http://www.issba.org on April 20, 2013 - 6:49 am

    Ur posting, “Excel: Sort by cell color | CPA Tech Tips” ended up being well
    worth commenting here! Just simply desired to announce you really did a fantastic work.

    Thanks a lot -Raymon

  4. #4 by http://Www.Ashdesignsonline.com on April 20, 2013 - 7:54 am

    I personally Believe that posting, “Excel: Sort by cell color | CPA Tech Tips” was in fact great!
    I reallycannot see eye to eye along with you more!
    At last seems like I personallystumbled upon a blog website well worth browsing.
    Thank you, Carrie

  5. #5 by http://Www.fonamih.org/ on April 20, 2013 - 11:42 am

    “Excel: Sort by cell color | CPA Tech Tips” was in fact really compelling and informative!
    Within the present day universe that is very difficult to
    do. Thank you, Katrice

  6. #6 by jimdo.com on April 22, 2013 - 2:59 am

    This posting, “Excel: Sort by cell color | CPA Tech Tips” demonstrates that you actually fully understand just what exactly u are writing about!
    I personally fully agree with your post. Thanks a lot -Marlys

  7. #7 by MrParacord.com- Paracords on April 22, 2013 - 5:44 pm

    I personally Feel blog post, “Excel: Sort by cell color |
    CPA Tech Tips” was indeed spot on! I actuallycouldn’t agree along with you more! Finally looks like I personallylocated a webpage well worth reading. Thanks for the post, Murray

  8. #8 by Vernell on August 9, 2013 - 1:21 pm

    Thanks a lot for applying free time to post “Excel:
    Sort by cell color | CPA Tech Tips”. Thanks a ton yet again -Marylyn

  9. #9 by Sean on August 16, 2013 - 9:32 pm

    “Excel: Sort by cell color | CPA Tech Tips” ended
    up being a fantastic blog. If merely there was significantly
    more blogs similar to this one in the the net. Well,
    many thanks for your time, Priscilla

  10. #10 by Hilario on April 4, 2014 - 1:52 pm

    Obviously such deals are pulling a large crowd to the market.
    These new Samsung TVS are actually the latest in LED technology and
    used LED, which stands for Light Emitting Diodes, instead of using cold cathode florescent tubes.
    But you won’t get some of the all time favorites that most
    TVs have.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: