How do I sort a column of different font colors by color?

[Guest]

Rather than using a new column for a key to each color, is there a way to
just sort the entries in a column based on the color of the font I have used?

 

[Guest]

You can but only with a User Defined Fuction.


The one below is for interior colour but note the comment on how to change
it to sort by font colour.

http://www.ozgrid.com/VBA/Sort.htm

Mike