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.
So here is a quick example:
Table B
as CheckList
Table A
and Hit ALT+H+L+NNew Formatting Rule
WindowUse a formula to determine which cells to format
=MATCH(A2,CheckList,0)