Default colour in cell based on specific entry

[Guest]

Please help!

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

Thanx.

 

[Bob Phillips]

Select A5
Menu Format>Conditional 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)

 

[David Biddulph]

Or if the cell you want highlighting is not A5 but the one that matches A5,
then select A1 to H1, Format/ Conditional Formatting/ Cell Value is:
Equal to/ =$A5
Format and choose your pink pattern.

 

[Guest]

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.

 

[David Biddulph]

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))