You will have to us vba code to add a color index in an adjoining column.
The sort is then done on the new column.

See ...
http://www.cpearson.com/excel/SortByColor.htm for a way to do this.
-or-
http://www.xldynamic.com/source/xld.ColourCounter.html
-or-
a commercial alternative...
http://www.officeletter.com/blink/specialsort.html
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Lewej"
wrote in message
Hi
Can we sort a spreadsheet on the infill colour?
We have a large list of names and addresses. About half are highlighted with
a blue infill colour, and the rest are default white.
Can we use sort - or any other method - to differentiate between these
records on a colour basis?
TIA
Lewej