Spreadsheet: 792824d1661180074-data-comparison-formula-find-matches-across-two-sets-of-data-excel-test
Sheet: Excel Test

 |  |  |  | Are any of the numbers from Table 1 in Table 2?
 |  |  |  | If they are (I know a small number are), I would like all those cells in Table 2 highlighted with a red fill automatically as I have loads ofspreadsheets to compare |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | like this
 |  |  |  | I have already created 'actual tables' of the number sets in each table, that can be clicked for quick reference of the two data sets in the drop down menu to the left of the excel typing bar
 |  |  |  | Example: | Table 1 has an entry in cell F38 (1234) and Table 2 has it duplicated in cell R20 (1234). I would like there to be a formula or rule in place so the spreadsheet knows about that match and highlights R20 in red fill |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1234
Table 2:
259 | 106 | 124 | 106 | 124 | 1168 | 363 | 514 | 1134 | 416 | 155 | 155 | 191 | 191 | 5708 | 520 | 828 | 1291 | 111 | 246 | 858 | 285 | 389 | 261 | 1554 | 2496 | 794 | 1947 | 3635 | 1411 | 4145 | 7874 | 89 | 81 | 117 | 1652
208 | 73 | 109 | 82 | 118 | 811 | 286 | 413 | 873 | 305 | 125 | 125 | 179 | 179 | 4490 | 383 | 607 | 970 | 98 | 197 | 701 | 230 | 278 | 232 | 1248 | 1830 | 657 | 1663 | 3118 | 1029 | 3021 | 5737 | 70 | 60 | 91 | 1049
261 | 108 | 117 | 108 | 117 | 2160 | 339 | 519 | 961 | 279 | 108 | 117 | 162 | 171 | 3537 | 357 | 555 | 979 | 107 | 251 | 2060 | 257 | 249 | 288 | 1566 | 1674 | 849 | 2335 | 4409 | 920 | 2587 | 4895 | 74 | 78 | 111 | 1202
244 | 136 | 136 | 136 | 136 | 1918 | 348 | 484 | 1049 | 377 | 143 | 143 | 197 | 197 | 5471 | 481 | 750 | 1182 | 129 | 237 | 1938 | 322 | 346 | 265 | 1464 | 2262 | 757 | 1990 | 3736 | 1298 | 3852 | 7327 | 83 | 73 | 109 | 1065
215 | 98 | 107 | 116 | 125 | 1421 | 293 | 427 | 880 | 298 | 109 | 118 | 163 | 172 | 4204 | 376 | 593 | 963 | 102 | 210 | 1461 | 285 | 269 | 233 | 1290 | 1788 | 679 | 1801 | 3387 | 1011 | 2963 | 5628 | 82 | 70 | 94 | 662
339 | 159 | 168 | 195 | 204 | 2103 | 469 | 673 | 1494 | 552 | 192 | 201 | 246 | 255 | 8508 | 682 | 1099 | 1707 | 161 | 332 | 2393 | 387 | 443 | 348 | 2034 | 3312 | 1046 | 2701 | 5063 | 1901 | 5683 | 10814 | 126 | 126 | 152 | 1429
189 | 90 | 99 | 90 | 99 | 576 | 267 | 375 | 784 | 270 | 99 | 108 | 153 | 162 | 2367 | 348 | 537 | 865 | 95 | 194 | 1076 | 269 | 285 | 146 | 1134 | 1620 | 574 | 1333 | 2477 | 893 | 2467 | 4664 | 60 | 60 | 85 | 1409
171 | 72 | 81 | 90 | 99 | 1575 | 249 | 339 | 696 | 234 | 63 | 72 | 126 | 135 | 3024 | 312 | 465 | 759 | 81 | 180 | 2115 | 197 | 229 | 189 | 1026 | 1404 | 542 | 1436 | 2701 | 798 | 2318 | 4402 | 57 | 71 | 76 | 745
160 | 61 | 61 | 61 | 61 | 637 | 264 | 316 | 685 | 245 | 92 | 92 | 101 | 101 | 3296 | 349 | 486 | 770 | 63 | 180 | 1647 | 196 | 212 | 160 | 960 | 1470 | 495 | 1201 | 2242 | 837 | 2391 | 4537 | 44 | 51 | 74 | 1184
208 | 100 | 109 | 100 | 109 | 739 | 286 | 413 | 908 | 332 | 116 | 125 | 152 | 161 | 4625 | 410 | 661 | 1032 | 104 | 212 | 1229 | 238 | 286 | 285 | 1248 | 1992 | 630 | 1554 | 2900 | 1136 | 3290 | 6248 | 66 | 72 | 95 | 1472
186 | 42 | 78 | 60 | 96 | 960 | 238 | 370 | 676 | 192 | 102 | 102 | 102 | 102 | 2046 | 244 | 382 | 682 | 68 | 176 | 680 | 162 | 186 | 153 | 1116 | 1152 | 610 | 1615 | 3044 | 620 | 1699 | 3206 | 59 | 39 | 78 | 735
254 | 101 | 110 | 101 | 110 | 2027 | 358 | 504 | 1094 | 394 | 142 | 142 | 160 | 160 | 6649 | 498 | 784 | 1234 | 95 | 239 | 1427 | 234 | 330 | 336 | 1524 | 2364 | 805 | 2143 | 4032 | 1357 | 4103 | 7812 | 72 | 89 | 115 | 1531
118 | 46 | 55 | 55 | 64 | 604 | 170 | 234 | 538 | 206 | 71 | 80 | 107 | 116 | 3203 | 258 | 410 | 626 | 49 | 112 | 454 | 154 | 162 | 149 | 708 | 1236 | 361 | 903 | 1688 | 710 | 2135 | 4064 | 45 | 41 | 54 | 564
153 | 72 | 81 | 72 | 81 | 1044 | 231 | 303 | 748 | 306 | 81 | 108 | 99 | 126 | 4860 | 384 | 609 | 901 | 72 | 144 | 684 | 131 | 203 | 163 | 918 | 1836 | 467 | 1138 | 2123 | 1077 | 3280 | 6254 | 54 | 56 | 74 | 1008
122 | 41 | 41 | 50 | 50 | 1715 | 200 | 241 | 542 | 202 | 67 | 67 | 103 | 103 | 4081 | 280 | 401 | 622 | 31 | 112 | 985 | 152 | 144 | 148 | 732 | 1212 | 407 | 1145 | 2168 | 722 | 2265 | 4328 | 32 | 31 | 56 | 495
255 | 120 | 129 | 120 | 129 | 1569 | 333 | 507 | 1025 | 339 | 123 | 150 | 159 | 186 | 3705 | 417 | 675 | 1109 | 115 | 241 | 1069 | 263 | 343 | 166 | 1530 | 2034 | 803 | 2044 | 3833 | 1136 | 3220 | 6101 | 80 | 73 | 112 | 1352
335 | 164 | 173 | 182 | 191 | 1640 | 439 | 666 | 1420 | 502 | 196 | 196 | 250 | 250 | 7225 | 606 | 1000 | 1587 | 161 | 323 | 1700 | 425 | 417 | 361 | 2010 | 3012 | 1038 | 2650 | 4965 | 1709 | 4988 | 9474 | 111 | 110 | 148 | 1707
148 | 67 | 76 | 85 | 94 | 859 | 200 | 294 | 638 | 230 | 68 | 68 | 140 | 140 | 3542 | 282 | 458 | 720 | 73 | 145 | 1099 | 220 | 236 | 205 | 888 | 1380 | 461 | 1183 | 2218 | 786 | 2331 | 4432 | 53 | 62 | 68 | 737
212 | 95 | 104 | 95 | 104 | 1130 | 290 | 421 | 1017 | 409 | 148 | 148 | 202 | 202 | 7087 | 487 | 815 | 1214 | 101 | 218 | 1370 | 364 | 324 | 235 | 1272 | 2454 | 651 | 1636 | 3060 | 1433 | 4394 | 8379 | 89 | 68 | 100 | 799
262 | 109 | 118 | 109 | 118 | 1243 | 340 | 521 | 1172 | 440 | 152 | 161 | 170 | 179 | 6938 | 518 | 877 | 1350 | 105 | 249 | 843 | 298 | 354 | 259 | 1572 | 2640 | 809 | 2031 | 3800 | 1522 | 4523 | 8606 | 87 | 90 | 121 | 1721
272 | 110 | 110 | 110 | 110 | 1694 | 376 | 540 | 1112 | 376 | 133 | 142 | 187 | 196 | 5164 | 480 | 748 | 1216 | 99 | 270 | 1674 | 290 | 314 | 294 | 1632 | 2256 | 855 | 2208 | 4144 | 1272 | 3664 | 6952 | 80 | 91 | 122 | 1738
148 | 67 | 67 | 112 | 112 | 1039 | 200 | 294 | 603 | 203 | 86 | 86 | 86 | 86 | 2039 | 255 | 404 | 658 | 74 | 164 | 2189 | 160 | 184 | 146 | 888 | 1218 | 454 | 1155 | 2162 | 683 | 1925 | 3647 | 52 | 36 | 65 | 684
227 | 110 | 110 | 110 | 110 | 2639 | 331 | 450 | 997 | 367 | 124 | 133 | 178 | 187 | 6181 | 471 | 730 | 1137 | 102 | 219 | 2289 | 251 | 267 | 226 | 1362 | 2202 | 726 | 1993 | 3759 | 1280 | 3953 | 7539 | 77 | 80 | 103 | 729
Table 1:
136 | 46 | 55 | 46 | 55 | 1234 | 188 | 270 | 591 | 215 | 80 | 80 | 107 | 107 | 4166 | 267 | 428 | 670 | 46 | 127 | 784 | 140 | 172 | 94 | 816 | 1290 | 450 | 1218 | 2300 | 747 | 2324 | 4433 | 41 | 38 | 61 | 458