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" wrote in message ...

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
XX


"Mark Fox"
wrote in message

Does anyone know how to sort by colour?
Either font colour or background colour.
Many thanks in advance.