See http://xldynamic.com/source/xld.Colo...r.html#sorting

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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