| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare lists and highlight matches
Hi,
I have two lists that I'm trying to compare to see if there are any similarities. The lists are quite extensive. Is there a formula out there which can match the entries AND highlight them? any help would be appreciated. thanx S. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare lists and highlight matches
Take a look he
http://www.cpearson.com/excel/duplic...tractingCommon "srain001" wrote: Hi, I have two lists that I'm trying to compare to see if there are any similarities. The lists are quite extensive. Is there a formula out there which can match the entries AND highlight them? any help would be appreciated. thanx S. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare lists and highlight matches
Several ways, have a look here
http://www.cpearson.com/excel/duplic...tractingCommon Mike "srain001" wrote: Hi, I have two lists that I'm trying to compare to see if there are any similarities. The lists are quite extensive. Is there a formula out there which can match the entries AND highlight them? any help would be appreciated. thanx S. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare lists and highlight matches
Assume lists are in columns A & B:
Highlight column B Format=Conditional Formatting FormulaIs: = COUNtIF(A:A,B1)=1 Format=Pattern .. set colour Matching values will be coloured. HTH "srain001" wrote: Hi, I have two lists that I'm trying to compare to see if there are any similarities. The lists are quite extensive. Is there a formula out there which can match the entries AND highlight them? any help would be appreciated. thanx S. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare lists and highlight matches | Excel Discussion (Misc queries) | |||
| Compare columns, count matches | Excel Worksheet Functions | |||
| I need to compare to columns and indicate the matches in another | New Users to Excel | |||
| How do I compare two Excel columns of numbers and see non-matches | Excel Worksheet Functions | |||
| compare info in 4 worksheets and highlight fields that are the sam | Excel Worksheet Functions | |||
Linear Mode
