I am trying to compare two columns in excel with the same unique identifier and highlight the cell if it is different:
<colgroup><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
In the above example I have 3 columns (Unique, Description, and Date) I am trying to compare the date on two separate sheets and highlight if they are different if the unique identifier matches.
Unique | Description | Date | Unique | Description | Date | |
123 | Test | 10/1/2018 | 126 | Test | 10/5/2018 | |
124 | Test | 10/2/2018 | 123 | Test | 10/2/2018 | |
125 | Test | 10/1/2018 | 124 | Test | 10/2/2018 | |
126 | Test | 10/5/2018 | 125 | Test | 10/1/2018 |
<colgroup><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
In the above example I have 3 columns (Unique, Description, and Date) I am trying to compare the date on two separate sheets and highlight if they are different if the unique identifier matches.