excelexcel-formulaexcel-2016

Conditional Formatting Formula to highlight all matching values found in another table


I am looking to use conditional formatting to highlight all values in the table that are found in another table. I am new to formulas for conditional formatting so please forgive my ignorance.

So

Table A                              Table B

*10 x 2*                             13 x 26
8 x 6                                20 x 20
*4 x 9*                              18 x 6
3 x 1                                40 x 1
18 x 2                               10 x 2
*6 x 6*                              4 x 9
*13 x 26*                            10 x 15
79 x 2                               6 x 6

So the formula will be conditional formatting for Table A, searching Table B for any matching values and highlight them in table A. In the above example * * serves as highlighting.

I have tried using countif/s but that is very clearly the wrong direction for conditional formatting. Other solutions I have found are only searching for specific words or phrases not searching all data in tables and matching.

Thanks in advance.


Solution

  • So here is a quick example:

    enter image description here



    =MATCH(A2,CheckList,0)