Spreadsheet: 691971d1597984827-conditional-formatting-finding-duplicates-across-multple-sheets-asset-management-and-location-information-3-
Sheet: Small Cage

 |  | Notes | Ordered? | Received | New CI | New CI S/N | New CI Model | Tag Number | CRQ | Old CI Name | Old CI S/N | Tag Number | Old [NAME] | Status | Status Reason / Last Connected | [NAME] | Product Categorization Tier 1 | Product Categorization Tier 2 | Product Categorization Tier 3 | System Role | System Environment | Company | Site | Room | Inventory Name | Managed By | Used By | Owner Name | Owner Contact | Submitter | Audit Date | Purchase Date | Received Date | Create Date | Confirmed Date | Last Scan Date | Disposal Date | [NAME] |  |  | Helper New CL | helper New CI S/N | Helper Old CL | helper Old CI S/N |  | Named range for sheet names
 | 1 | What I am trying to accomplish is when a cell here matches a cell on any of the other sheets, it is marked as duplicate on the sheets. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Small Cage
 | 2 | The rows that I will be tracking are F / G / and K / L.  They will be separate meaning I would want two different Comparisons. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 Refresh List
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 Completed Refresh
 | 4 | At any one time, this information should only be on one of these pages but when I am doing 20 or 30 in a day sometimes I forget to delete the old one. So it would look like this when it is the only one in the workbook. | 7/9/2020 | 8/11/2020 | [NAME] | CNDABC123 | HP 650 i7 G5 | 301100 | 12345 | lt3011010 | CNDXYZ123 | 3011010 | HP 650 i7 G2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 Changes
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 6 | But if it is anywhere in the [NAME] duplicated, on this sheet or otherwise I would like it to show like this.  Lets say this time it was the two serial Numbers.  I would want it to look like this on every sheet it is on. | 7/9/2020 | 8/11/2020 | [NAME] | CNDABC123 | HP 650 i7 G5 | 301100 | 12345 | lt3011010 | CNDXYZ123 | 3011010 | HP 650 i7 G2
 | 7
 | 8 | To complicate things, as I deal with thousands of lines on each sheet.  If it is possible to setup two different formats where one says if it is on the same sheet sheet show it in red like this.  Which I already know how to do. | 7/9/2020 | 8/11/2020 | [NAME] | CNDABC123 | HP 650 i7 G5 | 301100 | 12345 | lt3011010 | CNDXYZ123 | 3011010 | HP 650 i7 G2
 | 9
 | 10 | But the second formula is where I need everyones help.  The second one that says if it is somewhere else in the workbook as a duplicate show it like this on both pages or all pages where a duplicate lands. | 7/9/2020 | 8/11/2020 | [NAME] | CNDABC123 | HP 650 i7 G5 | 301100 | 12345 | [NAME] | CNDABC123 | 3011010 | HP 650 i7 G2
 | 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
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 67
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | 97
 | 98
 | 99
 | 100