Sort on infill colour
 

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

Sort on infill colour
 

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

Sort on infill colour
 

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

Sort on infill colour
 

Thanks Guys

Lewej

"Bob Phillips" wrote:

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