George

If you have Excel 2007, this functionality is built-in, with versions prior
you will need code

Some examples here

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
web: www.excelusergroup.org




"George A. Jululian" wrote in
message ...
how can i sort colour in a sheet

Regards