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!

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!

Thanks for trying but....

when I put a value in column A it merely highlights the first number in the
block (E20), then does not work at all for subsequent entries down Column A.

Any other ideas?

"Bob Phillips" wrote:

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!

Mick

You have another post going in another news group.

Why not stick to the one posting?

Bob has given you the same answer you got at other post.


Gord Dibben MS Excel MVP

On Wed, 2 Apr 2008 07:00:09 -0700, Mick B
wrote:

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!