Hi Angela,

See Chip Pearson's Sorting By color page at:

http://www.cpearson.com/excel/SortByColor.htm

---
Regards,
Norman



"Angela" wrote in message
...
Is there any way to sort by shade?