The Excel 2007 "Sort On" drop down lets you pick cell color or font color to
sort on. You'd have to see if it does what you need.

--
Jim
"Abbey Normal" wrote in message
...
|I don't know if this is even possible, but within excel (2007) Can i set up
| different sort criteria based on a value? Say for instance, I have one
column
| that I have colored blue. (which I have sorted to the bottom). So I want
to
| sort the stuff that on the top (which is not blue) in a different sequence
| from the stuff that is on the bottom. Ie. The stuff where the required
date
| is not blue should be sorted by Customer then PO# then Div. where the
blue
| should be sorted by Start Date Then by PO#, then by Div. Can I do this
| without cut/paste to a different worksheet?
| Thank you,