hi - hope someone can help!
i've got 5 cells in a row - i want to be able to input a number ( 1 to
5 ) into the 6th cell and automatically colour in the respective cell.
for example if i input number 3 - then i want cell number 3 to change
colour and all the rest to remain unfilled.

i've tried conditional formatting but that will only change the colour
of the input cell. i've tried the if function too but there doesn't
seem to be a option for changing cell colour.

any ideas?

cheers

AK