KunleExcel: Your code colours not only the duplicate but also the original. Also, it processes only the first row, not all rows. Finally, when posting code, please use the code tags, indicated by the # button on the posting menu. Without them, your code loses much of whatever structure it had.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]