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