Spreadsheet: 221603d1363622590-conditional-formatting-comparing-collumns-sample
Sheet: Sheet1

 |  | Coulumn 1 | Column 2 |  | Common data |  | Common data- 1.#N/A- says the data from column 1 does not exist in column 2. 2.if tehre is any other value apart from #N/A which means value exist in both columns(1 and 2).
 |  | B00000112615 | b00000114110
 |  | b00000112656 | b00000114122
 |  | b00000112806 | b00000114210
 |  | b00000112880 | b00000114250
 |  | b00000112912 | b00000114332
 |  | b00000112923 | b00000114377
 |  | b00000113059 | b00000114395
 |  | b00000113079 | b00000114515
 |  | b00000113184 | b00000114526
 |  | b00000113228 | b00000114602 |  |  |  |  | 1.select both colomns
 |  | b00000113270 | b00000114669 |  |  |  |  | 2.click on conditional formatting then manage rules
 |  | b00000113293 | b00000114717 |  |  |  |  | 3. click on new rule then format only duplicate or unique values
 |  | b00000113351 | b00000115003 |  |  |  |  | 4.click on format, check mark the strikethrough option under the font tab
 |  | b00000113377 | b00000115020 |  |  |  |  | 5.you can also add color under the fill tab by selecting any color and click on ok
 |  | b00000113390 | b00000115061
 |  | b00000113420 | b00000115067
 |  | b00000113447 | b00000115260
 |  | b00000113458 | b00000115338
 |  | b00000113582 | b00000115356
 |  | b00000113640 | b00000115525
 |  | b00000113672 | b00000115568
 |  | b00000113685 | b00000115582
 |  | b00000113717 | b00000115586
 |  | b00000113763 | b00000115602
 |  | b00000113827 | b00000115749
 |  | b00000113833 | b00000115828
 |  | b00000113867 | b00000115876
 |  | b00000113872 | b00000115953
 |  | b00000113932 | b00000115990
 |  | b00000113945 | b00000116006
 |  | b00000113960 | b00000116126
 |  | b00000113963 | b00000116330
 |  | b00000114056 | b00000116384
 |  | [NAME] | b00000116446
 |  | b00000114063 | b00000116462
 |  | b00000114110 | b00000116491
 |  | b00000114117 | b00000116504
 |  | b00000114122 | b00000116548
 |  | b00000114174 | b00000116559
 |  | b00000114210 | b00000116669
 |  | b00000114216 | b00000116748
 |  | b00000114250 | b00000116770
 |  | b00000114294 | b00000116801
 |  | b00000114332 | b00000116898
 |  | b00000114335 | b00000116996
 |  | b00000114377 | b00000117037
 |  | b00000114395 | b00000117080
 |  | b00000114430 | b00000117237
 |  | b00000114515 | b00000117296
 |  | b00000114526 | b00000117351
 |  | b00000114602 | b00000117386
 |  | b00000114615 | b00000117527
 |  | b00000114669 | b00000117648
 |  | b00000114680 | b00000117671
 |  | b00000114717 | b00000117693
 |  | b00000114730 | b00000117725
 |  | b00000114746 | [NAME]
 |  | b00000114929 | b00000117828
 |  | b00000115003 | b00000117864
 |  | b00000115020 | b00000117950
 |  | b00000115035 | b00000118002
 |  | b00000115061 | b00000118015
 |  | b00000115067 | b00000118020
 |  | b00000115085 | b00000118100
 |  | b00000115260 | b00000118158
 |  | b00000115324 | b00000118280
 |  | b00000115338 | b00000118458
 |  | b00000115356 | b00000118516
 |  | b00000115525 | b00000118545
 |  | b00000115564 | b00000118605
 |  | b00000115568 | b00000118646
 |  | b00000115582 | b00000118685
 |  | b00000115586 | b00000118713
 |  | b00000115602 | [NAME]
 |  | b00000115650 | b00000119035
 |  | b00000115749 | b00000119076
 |  | b00000115799 | b00000119116
 |  | b00000115828 | b00000119136
 |  | b00000115868 | b00000119303
 |  | b00000115873 | b00000119340
 |  | b00000115876 | b00000119347
 |  | b00000115953 | b00000119402
 |  | b00000115990 | b00000119567
 |  | b00000116006 | b00000119636
 |  | b00000116126 | b00000119776
 |  | b00000116238 | b00000119865
 |  | b00000116330 | b00000119887
 |  | b00000116384 | b00000119920
 |  | b00000116390 | b00000119946
 |  | b00000116446 | b00000119957
 |  | b00000116462 | b00000119980
 |  | b00000116491 | b00000119998
 |  | b00000116504 | b00000120197
 |  | b00000116529 | b00000120465
 |  | b00000116548 | b00000120496
 |  | b00000116559 | b00000120624
 |  | b00000116669 | b00000120667
 |  | b00000116695 | b00000120731
 |  | b00000116728 | b00000120779
 |  | b00000116748 | b00000120783
 |  | b00000116752 | b00000120812
 |  | b00000116770 | b00000120881
 |  | b00000116801 | b00000120902
 |  | b00000116897 | b00000120912
 |  | b00000116898 | b00000120987
 |  | b00000116996 | b00000121035
 |  | b00000117033 | b00000121038
 |  | b00000117037 | b00000121177
 |  | b00000117080 | b00000121182
 |  | b00000117237 | b00000121203
 |  | b00000117296 | b00000121278
 |  | b00000117351 | b00000121294
 |  | b00000117386 | b00000121417
 |  | b00000117399 | b00000121452
 |  | b00000117527 | b00000121472
 |  | b00000117648 | b00000121530
 |  | b00000117671 | b00000121549
 |  | b00000117693 | b00000121578
 |  | b00000117725 | b00000121711
 |  | [NAME] | [NAME]
 |  | b00000117803 | b00000121731
 |  | b00000117828 | b00000121736
 |  | b00000117864 | b00000121770
 |  | b00000117865 | b00000121780
 |  | b00000117950 | b00000121813
 |  | b00000117962 | b00000121821
 |  | b00000118002 | b00000122071
 |  | b00000118015 | b00000122169
 |  | b00000118020 | b00000122412
 |  | b00000118072 | b00000122426
 |  | b00000118100 | b00000122434
 |  | b00000118158 | b00000122466
 |  | b00000118236 | b00000122533
 |  | b00000118271 | b00000122614
 |  | b00000118280 | b00000122615
 |  | b00000118335 | b00000122727
 |  | b00000118458 | b00000122883
 |  | b00000118516 | b00000122927
 |  | b00000118545 | b00000122931
 |  | b00000118605 | b00000122976
 |  | b00000118646 | b00000123090
 |  | b00000118685 | b00000123095
 |  | b00000118713 | b00000123321
 |  | b00000118792 | b00000123383
 |  | b00000118798 | b00000123385
 |  | [NAME] | b00000123396
 |  | b00000119018 | b00000123413
 |  | b00000119035 | b00000123439
 |  | b00000119076 | b00000123470
 |  | b00000119114 | b00000123555