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

Comments:
Thanks Mike! I've alredy shared this tip (and this site) with four peole! Very, very good. Thanks.
 
Terrific, just solved my how-to-sort-one-thousand-rows-by-color trauma. Thanks so much!
 
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?
 
THANKS MIKE... AWeSOME TIP!!
 
Thanks Man! This rocks...
 
I never post comments, but your straight forward video has saved me a LOT of time. Thank you.
 
This was amazing! Thanks so much!
 
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!
 
This is ridiculously helpful!
 
This is ridiculously helpful!
 
Exactly what I needed... thanks for mentioning the "font" section as well... great tip!!!
 
Thanx buddy! I almost payed $29.99for this function.
 
I just used this. Thanks so much.
 
OMG. You are a lifesaver!!!!!!!

Thank you so much for your time.
 
Ace! Saved me loads of work!
 
Great function!!! Thank you very much :)
 
Damn good!!!!
 

Post a Comment


<< Home

 

 

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. This weblog is in no way associated with Microsoft.

This page is powered by Blogger. Isn't yours?