Conditional Formatting to match cell values

[Mick B]

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!

 

[Bob Phillips]

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]

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?

 

[Gord Dibben]

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