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

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?

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

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

"Jack" wrote:

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?