Hi Andrew,
Color, Sorting on Color, not recommended because changing
the color of a cell will not cause an event to occur that you can
pick up automatically at least not in any Excel
through Excel 2000, but the topic does come up. Also there is
the problem of color perception. However the following will help... http://www.mvps.org/dmcritchie/excel/colorsort.htm
You will probably want to look at the Case Statement example to
reassign a color index number to something more suitable for sorting order.
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.
