See
http://www.xldynamic.com/source/xld....r.html#sorting for a
working solution
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Diane" wrote in message
...
I have 4 colours on my spreadsheet, how do I sort the data by the colour?