Hi,

Sorry yet another simple question.

I have numbers, (1,2,3 etc) in cells I5 to I9 from which I would like to
generate a colour in cells B5-9, (black, white, red etc). If I change I6
from 4 to 9 the colour in B6 updates as soon as I hit return or the down key
after entering the number.

What is the easiest way to do this?
Thanks