Spreadsheet: 62776d1263775518-conditional-formatting-if-one-cell-holds-same-data-as-another-example_lottery
Sheet: example_lottery

Date | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | BONUS
2009-09-25 00:00:00 |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 17 |  | 19 |  |  |  |  |  | 25 |  |  |  |  |  | 31 |  |  |  |  |  |  | 38 |  |  |  |  |  |  |  | 46 |  |  |  | 4
2009-10-30 00:00:00 |  |  |  |  |  |  |  |  | 9 | 10 |  |  |  | 14 |  |  | 17 | 18 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46 |  |  |  | 6 |  |  | 4 | 12 | 19 | 31 | 32 | 33 | 45 |  | 11 | 17 | 18 | 20 | 25 | 46 | 47 |  | 6 | 12 | 30 | 34 | 43 | 44 | 46
2009-10-23 00:00:00 |  |  |  |  |  |  | 7 |  |  | 10 |  | 12 |  |  |  |  |  | 18 |  |  |  |  | 23 |  | 25 |  |  |  |  |  |  |  |  |  |  | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
2009-10-16 00:00:00 |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  | 18 |  | 20 |  |  |  |  |  |  |  |  | 29 |  | 31 |  |  |  | 35 |  |  |  |  |  |  |  |  | 44 |  |  |  |  |  | 4
2009-10-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  | 25 | 26 |  |  |  |  |  |  |  |  |  |  |  | 38 |  |  |  | 42 |  |  |  | 46 | 47 |  |  | 5
2009-10-02 00:00:00 |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | 28 | 29 |  | 31 | 32 |  |  | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
2009-11-27 00:00:00 |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  | 15 |  |  |  |  |  |  |  |  | 24 |  | 26 |  |  |  |  |  |  |  |  |  |  | 37 | 38 |  |  |  |  | 43 |  |  |  |  |  |  | 17 |  |  | 6 | 7 | 9 | 27 | 40 | 45 | 47 |  | 13 | 18 | 26 | 27 | 39 | 40 | 42 |  | 6 | 14 | 28 | 32 | 33 | 36 | 37
2009-11-20 00:00:00 |  | 2 |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  | 30 |  |  |  |  |  | 36 |  |  | 39 |  |  | 42 |  |  |  |  |  |  |  | 24
2009-11-13 00:00:00 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 18 |  |  |  |  |  |  |  |  | 27 | 28 |  |  |  |  |  |  |  |  |  | 38 |  |  | 41 |  |  |  |  |  |  | 48 |  | 36
2009-11-06 00:00:00 |  | 2 |  |  |  |  | 7 | 8 |  |  | 11 | 12 |  |  |  | 16 | 17 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
2009-12-25 00:00:00 |  |  |  |  |  |  |  | 8 | 9 |  |  | 12 | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 30 | 31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47 |  |  | 8 | 15 | 22 | 25 | 40 | 47 | 48 |  | 14 | 16 | 20 | 27 | 31 | 40 | 45 |  | 1 | 10 | 11 | 13 | 17 | 19 | 35 |  | 3 | 4 | 30 | 32 | 41 | 43 | 46 |  | 10 | 11 | 15 | 21 | 23 | 25 | 46 |  | 1 | 17 | 22 | 23 | 27 | 31 | 37
2009-12-18 00:00:00 |  |  |  |  |  |  |  | 8 |  | 10 |  |  |  |  | 15 |  | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | 34 | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  |  | 4 | 17 | 19 | 20 | 23 | 28 | 49 |  | 12 | 19 | 21 | 33 | 35 | 46 | 47 |  | 19 | 22 | 23 | 33 | 35 | 39 | 42 |  | 1 | 18 | 25 | 28 | 33 | 37 | 48 |  | 4 | 15 | 24 | 27 | 31 | 35 | 49 |  | 6 | 11 | 20 | 21 | 36 | 38 | 47
2009-12-11 00:00:00 | 1 |  |  | 4 | 5 |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 |  | 13
2009-12-04 00:00:00 | 1 |  |  |  |  | 6 | 7 |  |  |  |  |  | 13 |  |  |  |  |  | 19 |  |  |  |  |  |  |  |  |  |  |  |  | 32 |  |  | 35 |  |  |  |  | 40 |  |  |  |  |  |  |  |  |  | 1 |  |  | 16 | 23 | 27 | 29 | 34 | 35 | 48 |  | 11 | 21 | 24 | 32 | 34 | 44 | 45 |  | 12 | 20 | 27 | 42 | 44 | 45 | 47
2010-01-01 00:00:00 |  |  |  |  |  |  | 7 |  | 9 |  |  |  | 13 |  |  |  |  | 18 |  |  |  |  |  |  |  |  | 27 |  |  |  |  |  | 33 |  |  |  |  |  |  |  |  |  |  | 44 |  |  |  |  |  | 15 |  |  | 4 | 7 | 15 | 27 | 33 | 45 | 48 |  | 18 | 24 | 26 | 33 | 39 | 41 | 46 |  | 13 | 16 | 22 | 26 | 31 | 35 | 48
2010-01-08 00:00:00 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 17 |  |  |  | 21 |  | 23 | 24 |  |  |  | 28 |  |  |  |  |  |  |  |  |  |  | 39 |  |  |  |  |  |  |  |  |  |  | 31
2010-01-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  |  | 17 |  |  |  |  | 22 |  |  |  |  |  |  |  | 30 |  |  |  | 34 |  |  |  |  |  |  |  |  | 43 |  |  |  |  |  | 49 | 48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | these are ticket numbers
 |  |  |  |  |  |  |  |  |  |  |  |  | these numbers are drawn in and sorted to column by formula
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I want these cells above to be filled by colour if / when a number matches
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a number drawn (to left) like this --> |  |  |  |  |  |  |  |  |  | 5