Sort by colour

Does anyone know how to sort by colour? Either font colour or background
colour.

Many thanks in advance.

Hi Mark

You can find info here

http://www.cpearson.com/excel/SortByColor.htm

Or

http://www.xldynamic.com/source/xld.ColourCounter.html


EasyFilter Beta 2.1 can filter on Colors
(Bottom of the page)
http://www.rondebruin.nl/easyfilter.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Mark Fox" <fox.m@btopenworld.com> wrote in message news:dfn8rv$lj7$1@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com...
>
> Does anyone know how to sort by colour? Either font colour or background colour.
>
> Many thanks in advance.
>
>
>

Mark,

Excel cannot sort by color, however my Excel add-in
"Special Sort" - rel 1.31, should do what you want.
It adds 11 sort features not found in Excel, including sorting by.. .
color (cell color or font color)
prefix, suffix or middle (where you specify the length/position).
dates, number group, length, reverse, random and others.
Comes with a 2 page install/use Word file.
It is available - free - upon direct request.
Remove XXX from my email address.

Regards,
Jim Cone
San Francisco, USA
jim.coneXXX@rcn.comXXX


"Mark Fox" <fox.m@btopenworld.com>
wrote in message
news:dfn8rv$lj7$1@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com
Does anyone know how to sort by colour?
Either font colour or background colour.
Many thanks in advance.