Hi Kent

Take a look here
http://www.cpearson.com/excel/SortByColor.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Kent" wrote in message ...
I have a large spreadsheet within which I have set coloured backgrounds
for a lot of the cells randomly within one column.

How can I sort the list so all the coloured cells (and the rest of the
associated row) appear on top of each other.

thanks