Sorting by colour

[Joe]

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.

 

[MartinW]

Hi Joe,

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

HTH
Martin

 

[Pete_UK]

Here's another reference site for this:

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

Hope this helps.

Pete