Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
matching problem | Excel Discussion (Misc queries) | |||
Matching Problem Possible? | Excel Discussion (Misc queries) | |||
Matching data and linking it to the matching cell | Links and Linking in Excel | |||
A matching problem | Excel Worksheet Functions | |||
matching problem using VBA | Excel Worksheet Functions |