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