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