I have a scoring sheet that I need to color the final placings according to ribbon colors (normally 1 - 10).

I am using Excel 2003 and Conditional Formatting only gives 3 conditions. I have seen VBA code before, but I cannot get it to work.

Help please!