Cell Matching Problem ...
 

Small spreadsheet as follows:

A B C D E F
1 5 6 10 15 27 49
2
3 6 9 17 22 29 36
4 3 14 24 36 39 49
5 2 6 25 28 29 33

Problem:
When I enter a value in A3, B3, C3 and so on, I would like each value to be
checked against the values that appear in cells A1 to F1. If the value does
appear in the range then change the font to a different colour otherwise
leave the font colour the same. The same for A4 to F4 and A5 to F5.

Any ideas on how I could implement this please?

Many thanks,

Joe.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.686 / Virus Database: 447 - Release Date: 14/05/2004

Cell Matching Problem ...
 

Hi
try the following:
- select cells A3:F10
- goto 'Format - Conditional Format'
- enter the following formula
=COUNTIF($A$1:$F$1,A3)0
- select your format (other font)

--
Regards
Frank Kabel
Frankfurt, Germany

"Joe Best" schrieb im Newsbeitrag
...
Small spreadsheet as follows:

A B C D E F
1 5 6 10 15 27 49
2
3 6 9 17 22 29 36
4 3 14 24 36 39 49
5 2 6 25 28 29 33

Problem:
When I enter a value in A3, B3, C3 and so on, I would like each value
to be
checked against the values that appear in cells A1 to F1. If the
value does
appear in the range then change the font to a different colour
otherwise
leave the font colour the same. The same for A4 to F4 and A5 to F5.

Any ideas on how I could implement this please?

Many thanks,

Joe.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.686 / Virus Database: 447 - Release Date: 14/05/2004

Cell Matching Problem ...
 

Select A3:F5, goto FormatConditional formatting, and change condition 1 to
Formula Is, with a formula of
=ISNUMBER(MATCH(A3,$A$1:$F$1,0))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Joe Best" wrote in message
...
Small spreadsheet as follows:

A B C D E F
1 5 6 10 15 27 49
2
3 6 9 17 22 29 36
4 3 14 24 36 39 49
5 2 6 25 28 29 33

Problem:
When I enter a value in A3, B3, C3 and so on, I would like each value to
be
checked against the values that appear in cells A1 to F1. If the value
does
appear in the range then change the font to a different colour otherwise
leave the font colour the same. The same for A4 to F4 and A5 to F5.

Any ideas on how I could implement this please?

Many thanks,

Joe.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.686 / Virus Database: 447 - Release Date: 14/05/2004

Cell Matching Problem ...
 

Much appreciated Frank. Sorted now.

Joe.


"Frank Kabel" wrote in message
...
Hi
try the following:
- select cells A3:F10
- goto 'Format - Conditional Format'
- enter the following formula
=COUNTIF($A$1:$F$1,A3)0
- select your format (other font)

--
Regards
Frank Kabel
Frankfurt, Germany

"Joe Best" schrieb im Newsbeitrag
...
Small spreadsheet as follows:

A B C D E F
1 5 6 10 15 27 49
2
3 6 9 17 22 29 36
4 3 14 24 36 39 49
5 2 6 25 28 29 33

Problem:
When I enter a value in A3, B3, C3 and so on, I would like each value
to be
checked against the values that appear in cells A1 to F1. If the
value does
appear in the range then change the font to a different colour
otherwise
leave the font colour the same. The same for A4 to F4 and A5 to F5.

Any ideas on how I could implement this please?

Many thanks,

Joe.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.686 / Virus Database: 447 - Release Date: 14/05/2004





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.686 / Virus Database: 447 - Release Date: 14/05/2004

Cell Matching Problem ...
 

Much appreciated Bob. Sorted now.

Joe.


"Bob Phillips" wrote in message
...
Select A3:F5, goto FormatConditional formatting, and change condition 1
to
Formula Is, with a formula of
=ISNUMBER(MATCH(A3,$A$1:$F$1,0))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Joe Best" wrote in message
...
Small spreadsheet as follows:

A B C D E F
1 5 6 10 15 27 49
2
3 6 9 17 22 29 36
4 3 14 24 36 39 49
5 2 6 25 28 29 33

Problem:
When I enter a value in A3, B3, C3 and so on, I would like each value to
be
checked against the values that appear in cells A1 to F1. If the value
does
appear in the range then change the font to a different colour otherwise
leave the font colour the same. The same for A4 to F4 and A5 to F5.

Any ideas on how I could implement this please?

Many thanks,

Joe.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.686 / Virus Database: 447 - Release Date: 14/05/2004






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.686 / Virus Database: 447 - Release Date: 14/05/2004