Hi Joe,

Take a look at Bob Phillip's site.
http://xldynamic.com/source/xld.ColourCounter.html

HTH
Martin


"Joe" wrote in message
...
Hello

Is it possible to sort a list by font colour?

I am trying to find an easy way to synchronise the data between two
spreadsheets and am thinking that colour-coding the text in one of the
spreadsheets would make this process easier.

Thanks for your help!

Joe.