Thread: How do I sort a column of different font colors by color?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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?
Reply With QuoteReply With Quote