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!