use conditional formatting

regards
Krum


U¿ytkownik "NRG_eyes" napisa³ w
wiadomo¶ci ...
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