Default colour in cell based on specific entry
 

Please help!

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

Thanx.


--
KCG

Default colour in cell based on specific entry
 

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

Default colour in cell based on specific entry
 

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.
--
David Biddulph

"Bob Phillips" wrote in message
...
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

Default colour in cell based on specific entry
 

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

Default colour in cell based on specific entry
 

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