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.
