im useing excell on office 2003 and have desgined a way of recordeing who has
had their apprisal and what the overall result is. to grade the apprisals we
have a colur scheme of red,amber,green and blue.

i would like to be able to type the overall grade e.g blue and the cell
colour to change to blue when return is pressedso i can see the overall
results at a clance by the the color of the cell