Try conditional formatting with a formula of

=COUNTIF(E20:I27,A1)0

and format as required

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mick B" wrote in message
...
I have entered the values 1-40 in a block of cells, say E20:I27.

I want to enter the numbers 1-40 in a random order down Column A. When the
value has been entered down Column A I want the corresponding value in the
range E20:I27 to be formatted in some way. I have tried a few variations
but
had no joy!