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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sort by colors 4
Sorting by Color in Excel 2003 5
Sorting by color of font 4
How to filter rows data based on background color of individual cells 1
VBA- Excel Programming:- 0
Excel VBA - Problem with Closing Print Preview 0
Is there a way to sort by format in Excel? 1
Background stays when sorting 2

Back
Top