Cell Matching Problem ...

  • Thread starter Thread starter Joe Best
  • Start date Start date
J

Joe Best

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.
 
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)
 
Select A3:F5, goto Format>Conditional 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)
 
Much appreciated Frank. Sorted now.

Joe.


Frank Kabel said:
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)
Click to expand...
 
Much appreciated Bob. Sorted now.

Joe.


Bob Phillips said:
Select A3:F5, goto Format>Conditional 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)
Click to expand...
 
Back
Top