Excel Tutorials

Monday, May 02, 2005

Sort by Color?

As of Excel 2003, there is no inherent functionality that allows you to sort by color. However, with an easy custom function, you can gain this functionality without breaking a sweat.
Click on this link to see how: http://www.datapigtechnologies.com/flashfiles/SortonColor.html

70 Comments:

  • Thanks Mike! I've alredy shared this tip (and this site) with four peole! Very, very good. Thanks.

    By Anonymous Anonymous, At 2:45 PM  

  • Terrific, just solved my how-to-sort-one-thousand-rows-by-color trauma. Thanks so much!

    By Blogger sjl, At 6:11 AM  

  • This works great !! I have one more issue with color, however.

    We do a lot of conditional formating using color. This method does not work for cells that are colored by conditional formating.

    Do, you have a solution/macro for this?

    By Anonymous Anonymous, At 8:46 AM  

  • THANKS MIKE... AWeSOME TIP!!

    By Blogger mm, At 7:50 AM  

  • Thanks Man! This rocks...

    By Blogger JohnBaloney, At 7:28 AM  

  • I never post comments, but your straight forward video has saved me a LOT of time. Thank you.

    By Blogger M, At 5:59 AM  

  • This was amazing! Thanks so much!

    By Anonymous Anonymous, At 3:35 PM  

  • These directions were so easy to follow and I saved a lot of time by listening to your short and clear instructions. Thanks so much for sharing your knowledge!

    By Blogger Beth, At 6:21 AM  

  • This is ridiculously helpful!

    By Anonymous Anonymous, At 8:53 AM  

  • This is ridiculously helpful!

    By Anonymous Anonymous, At 8:54 AM  

  • Exactly what I needed... thanks for mentioning the "font" section as well... great tip!!!

    By Anonymous Anonymous, At 12:40 PM  

  • Thanx buddy! I almost payed $29.99for this function.

    By Anonymous Anonymous, At 5:40 PM  

  • I just used this. Thanks so much.

    By Anonymous Anonymous, At 8:07 AM  

  • OMG. You are a lifesaver!!!!!!!

    Thank you so much for your time.

    By Anonymous Anonymous, At 7:07 AM  

  • Ace! Saved me loads of work!

    By Anonymous enorlin, At 8:07 AM  

  • Great function!!! Thank you very much :)

    By Anonymous Anonymous, At 3:42 AM  

  • Damn good!!!!

    By Anonymous Anonymous, At 8:09 AM  

  • THANKS!!
    in one minute i'm already done with something that would have taken an hour.

    By Anonymous Anonymous, At 1:23 AM  

  • Great tip!! Excel should hire you!

    By Anonymous Anonymous, At 1:29 PM  

  • Thanks. That's awesome! saved tons of time

    By Blogger 9h0s7, At 8:03 AM  

  • I wish I could explain to you how much this has helped me! THANKS!

    By Anonymous Anonymous, At 9:58 AM  

  • This saved by life! Very slick and great directions. Thank you SO MUCH!

    By Blogger aseikonia, At 6:06 PM  

  • This was beyond helpful, Thanks so much!!!

    By Anonymous Anonymous, At 12:48 PM  

  • The quickest and easiest solution to this question I've encountered, and finally one that works, thanks for the information.

    By Anonymous Anonymous, At 9:44 PM  

  • Nice Tutorial, it works on manually colored cells, but it doesn't work on colored filled cells as a result of conditional format. could anybody show how it works on the latter. Thanks.

    By Anonymous Anonymous, At 10:09 AM  

  • Thanks a lot for the guidance Mike! Best Wishes to you for your effort.

    By Anonymous Anonymous, At 9:31 AM  

  • Mike Alexander you wold have never thought that some one in on the other side of the world would thanks you for this. This was great as u NOW know that the 2007 excel has it as an inbuilt sort function but 2003 doesnt. thanks u have been really helpful

    By Anonymous Anonymous, At 6:02 AM  

  • Thank you so much for this demo! This was extremely helpful!!!! A thousand times thanks!

    By Blogger Wolfsaben, At 12:55 PM  

  • Thank you so much! This is the most easy-to-understand Excel tutorial I've ever seen. Keep up the great work!!

    By Anonymous Anonymous, At 11:55 AM  

  • sweeeeet

    By Anonymous Anonymous, At 2:37 PM  

  • This was awesome!!! Thank you so much for yoru help.

    By Blogger ideaspurt, At 8:17 AM  

  • This was awesome! Thank so much for your help.

    By Blogger ideaspurt, At 8:18 AM  

  • That was amazing- great tip and fantastic tutorial. THANK YOU SO MUCH!

    By Anonymous Anonymous, At 5:19 PM  

  • Why can't every excel tutorial be this straight forward? Thank you! Still useful in 2010!

    By Anonymous Ruthy Stapleton, At 4:33 PM  

  • That was so EASY!!!!, loved being to pause it and type it out as he is doing it - THANK YOU!!

    By Anonymous Anonymous, At 8:05 AM  

  • I am probably just echoing all of the feedback you already received, but it helped me identify 8,400 rows out of 24,800 in about 30 seconds...which would have taken hours. THANKS A MILLION!!!

    By Anonymous Kerri, At 8:20 AM  

  • Thank you so much. This was perfect. Thank you.

    By Anonymous Pickgreen, At 8:40 AM  

  • thank you, work perfectly

    By Anonymous Anonymous, At 9:33 AM  

  • Thanks Mike - great! Really Helped.

    By Anonymous Anonymous, At 11:30 AM  

  • Fantastic Video, you are a champ. Hats off to you!!!

    By Anonymous Anonymous, At 9:13 AM  

  • I am glad that I came across this page.Thanks a ton for sharing, it really worked great!

    By Anonymous Anonymous, At 8:42 AM  

  • Thank you so much.It saved so much of time.

    By Anonymous Anonymous, At 8:45 AM  

  • Thanks for the wonder tip!

    By Blogger William, At 4:27 PM  

  • Excellent instructions!!! Wish you would have said how to make work for ANY Excel Document. I am new to macros and I'm very intimidated by Visual Basic, but this was so easy to do. I may give VB a second chance.

    By Anonymous Anonymous, At 10:39 AM  

  • This is great - my team and I were struggling for a long time on how to do this and we totally love this presentation! You just saved us HOURS of time!

    By Anonymous Jorg, At 11:04 AM  

  • Thank you for this link and credit to the video maker.

    By Anonymous Anonymous, At 1:47 AM  

  • Awesome, awesome tip! made me a hit with all the ladies in my office! Hahaha.

    By Anonymous Anonymous, At 12:37 PM  

  • Awesome job, thank you so much

    By Anonymous Anonymous, At 11:53 AM  

  • This is really helpful tip all other websites has codes but not visual example like this site which is most usefull.

    By Anonymous Anonymous, At 9:03 AM  

  • Function GetColor (Mycell as Range)

    GetColor = Mycell.Interior.ColorIndex

    End Function

    By Anonymous Anonymous, At 12:01 PM  

  • bravo mike you are greate

    By Blogger jim, At 6:53 AM  

  • Thanks, Mike! You're a genius!

    By Anonymous Anonymous, At 11:34 AM  

  • Mike...u r indeed great. Solved my problem. Thanks a lot.

    By Anonymous Michael Paul, At 11:28 PM  

  • excellent!!!!

    By Blogger LE, At 10:17 AM  

  • Outstanding. I used this years ago, but lost the code. Thanks for a great explanation.

    By Anonymous Anonymous, At 1:20 PM  

  • Dude. You saved me tons of time. Thanks!

    By Anonymous Marcus, At 2:53 PM  

  • You're a lifesaver! My color-coded wedding guests and I thank you!

    By Anonymous Anonymous, At 1:10 PM  

  • Mike you are the BEST!!!! This is my first macro, ou made me feel like an excel PRO!!! Thanks again :).

    By Anonymous Anonymous, At 10:59 AM  

  • Starting with Office 2007, colour sorting was added as a function in Excel. Under the Data menu, select sort. In the sort dialogue box, change the "sort on" column to Cell Color.

    By Anonymous Anonymous, At 1:17 PM  

  • This is still helpful as of 2011 (for those still using Office 2003).

    By Anonymous Joe, At 7:24 PM  

  • Awesome!!! Thanks for this workaround.

    By Anonymous Anonymous, At 8:18 AM  

  • Just what i was looking for, Thanks

    By Anonymous Anonymous, At 2:52 PM  

  • Thank you so much, this helped a ton. Is there any way to make this function work for anyone who opens the file? I manage the file most of the time, but others are allowed to go in and make changes. When they do and save the file, then all of the color values turn to a #name error until I open the file and save it again. Any suggestions?

    By Blogger ams5959, At 7:56 PM  

  • Beth said it best, "These directions were so easy to follow and I saved a lot of time by listening to your short and clear instructions". Thanks so much for sharing this information and making it SO easy!

    By Anonymous Cindy, At 12:57 PM  

  • Unbelievable! I'm so glad I did a google search and stumbled on this....you have no idea how much time this saved me. THANK YOU!

    By Anonymous Anonymous, At 7:57 AM  

  • Thank You So much..I cant Express it...U have Saved my One week time..Thanks A LOt

    By Anonymous Anonymous, At 12:33 AM  

  • thank you so much, this is awesome!!!

    By Blogger Melissa Donnett, At 1:11 PM  

  • This does not work with conditional formatting. I identified my duplicates by using conditional formatting to color all my duplicates yellow. When I added in the macro for the =GetColor(a2)and I replicated the formula for the rest of the column, I got the number for the color white (or no color) for every cell. This still does not fix my problem of easily finding which records in Excel are non-duplicates. Can anyone help?

    By Blogger Kevin Collier, At 6:26 AM  

  • Thank you! Save me a lot!

    By Anonymous Anonymous, At 3:54 PM  

  • Thanks a lot for this excellent piece.

    By Anonymous Anonymous, At 5:21 AM  

Post a Comment

Subscribe to Post Comments [Atom]



<< Home