Highlighting duplicates across many sheets
I have seen many posts on this topic, but so far nothing has worked. I have about 13 sheets of data, for which I am only concerned with column D. I want to highlight any duplicate entries in column D from sheet 4 through 13 (I have renamed them)--only highlight, as I want to review them before deleting. A clear guide would be much appreciated.
Thanks a lot.
|