Hi Nick,
It can be done but not efficiently, it would be better to
use numbers for sorting purposes and Conditional Formatting
to supply the color rather than the other way around.
For what you ask see Chip Pearson's
SortByColor -- Sorting by Color http://www.cpearson.com/excel/SortByColor.htm
if colors came from conditional formatting then use the
same formulas on the page and sort them, though see
bottom of page for C.F. colors.
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.