Change Bob's method as follows:
With A1 to H1 selected & A1 active, use Conditional Formatting with Formula
Is:
=ISNUMBER(MATCH(A1,$A$5:$H$5,0))
--
David Biddulph

"KCG" wrote in message
...
Hello Bob,

Here is my problem defined a little better:

I want to enter a value in any cell in the range A5:H5. If the value which
I
entered, also appears in A1:H1, then I want that found value in the range
A1:H1 to be coloured pink.

Thanx once again.

--
KCG


"Bob Phillips" wrote:

Select A5
Menu FormatConditional Formatting
Change Condition 1 to Formula Is
Add a formula of =ISNUMBER(MATCH(A5,$A$1:$H$1,0))
Click the Format button
Select the Pattern Tab
Select pink
OK
OK


--
HTH

Bob

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

"KCG" wrote in message
...
Please help!

If the value entered in cell A5 also appears in the range A1:H1, then
colour
that cell pink.

Thanx.


--
KCG