Is there a way to Sort data by color in Excel?
 

I am trying to sort data by color, is that possible?

see http://www.xldynamic.com/source/xld....r.html#sorting

--
HTH

Bob Phillips

"SRTUC" wrote in message
...
I am trying to sort data by color, is that possible?

You're gonna need a User defined function to get the value of a color.

See Chip Pearson's site for a nice version:
http://www.cpearson.com/excel/colors.htm
Look for: Returning The ColorIndex Of A Cell

Then you could use that UDF in a separate column and sort by that column.

SRTUC wrote:

I am trying to sort data by color, is that possible?

--

Dave Peterson