Martin

Excel cannot do this without help.

See Chip Pearson's site for code.

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

Or Bob Phillips' site

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


Gord Dibben MS Excel MVP


On Fri, 21 Jul 2006 03:20:01 -0700, Martin
wrote:

Hello, I have been given a rather large database sheet in Excel and some of
the line records have been coloured red, green and standard black. Is there a
way I can sort the records by colour i.e. red first the green then black?

Any tips or ideas most welcome Thanks Martin