Thanks for the tips... I have used the conditioning formats before, I just
dont understand why Microsoft hasnt built the color sorting into excel, seems
like it would be helpful to have that.

I am trying the 3rd party addins right now and trying to figure out a
workaround, thanks again to all for the help.

Jeff

"Mark Lincoln" wrote:

Rather than color the rows manually, I would put codes ("W", "L" and
something for "In Progress" in the example given) in the first column
and use Conditional Formatting to color the rows based on the codes.
(What can I say? I'm lazy.) Then I'd perform a sort on that column,
basing the order on what I'd like to see first.