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:

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:

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

My sort window looks like this:

The result looks like this:

This entry was posted on May 18, 2011, 2:03 pm and is filed under Excel. You can follow any responses to this entry through RSS 2.0. You can leave a response, or trackback from your own site.

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