Sort on infill colour

[Guest]

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

 

[Jim Cone]

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" <[email protected]>
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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

 

[Guest]

Thanks Guys

Lewej

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

--
HTH

Bob Phillips

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