I'm moving into realms I have not been before.
But I'll try and explain what I am trying to do. I have 3 columns with lists of part numbers ie :
Column 1 Column 2 Column 3
1 AB123 AB122 AB121
2 AB124 AB123 AB122
3 AB125 AB124 AB123
(Note: These lists will be copied and pasted from different locations into 1 worksheet)
What I would like the function to do is look at the 3 columns, and highlight all the duplicates, for example, colour the cells green ?.
So Column 1 line 1, Column 2 line 2 and Column 3 line 3 would all get highlight green.
Is that possible?.
Cheers,
Daywalker.
Bookmarks