Basically I have a spreadsheet which shows months Sep ,Oct, Nov and Dec we have to tracking ID number so if ID number is sheet Sep or Oct I want to highlight it as duplicates data so that case I am informed that ID number has been last month. What I am trying to do is highlight duplicate ID Numbers across the worksheets as we shouldn't have the same ID Number in the two different sources.
See attachment.
Bookmarks