I would use a helper column that would return the colorindex of the cell.

Chip Pearson has a routine that will do that:
http://cpearson.com/excel/colors.htm

Then I could sort my data by that column and the info in column A.

Remember that if you change colors, those UDFs that return the colorindex won't
recalculate. You'll want to force a manual recalculation before you trust the
results.

RyanH wrote:

I have a spreadsheet that I use to keep track of ship dates. Currently if a
particular product is ready to ship I highlight the ship date cell by
changing its interior color = 31. All ship dates are in Column K. Is there
a way to sort the entire worksheet in this order:

1.) all .Interior.ColorIndex = 31 at the top
2.) then sort the dates of those cells in ascending order
3.) then sort all other dates after the .Interior.ColorIndex = 31 by
ascending order
4.) then sort those cells by Sales order number in Column A

Is this possible?

--

Dave Peterson