Sorry for the short answer, but to the best of my knowledger there is no
way. One work around would be to add a column and type a color code
(b=blue, r=red) and then sort on that.


--
yesac142
------------------------------------------------------------------------
yesac142's Profile: http://www.excelforum.com/member.php...o&userid=24391
View this thread: http://www.excelforum.com/showthread...hreadid=380145