A blog for listing new Microsoft Excel tutorials.
Monday, May 02, 2005Sort 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:
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?
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!
Post a Comment
| |
SubscribeExcel Tutorial LinksExcel Templates
Archives
Syndicate |