Hello all -
I have two relatively long lists of data that are each located on separate tabs 'Display' and 'Data'. One list or the other are constantly being updated and it makes data integrity/accuracy an issue.
What I would love to happen is to create a conditional format where if an Exact text string is located in the 'Display' tab, but not in the 'Data' tab, then that text string will be highlighted in Display and vice versa.
Miscellaneous information:
- Display tab, the column of interest is in D:D
- Data tab, the column of interest is in C:C
- Duplicate values in the same sheet are not a concern whatsoever (Data list can contain the word "apple" 10 times, but as long as the Display tab contains 1 match it will not highlight)
So in summary I just need to make sure that if the word 'apple' is on the first sheet then it needs to also be on the 2nd sheet, so if one or the other are highlighted it basically would just flag me to review whether I need to delete that value or to have it added to the other. Obviously it's not the perfect system - but it will sure make it hell of a lot easier!
If any additional clarification / information is needed, please let me know!
Bookmarks