Hi nankw8,

Thanks for the code it works like charm.

However, I missed to inform that Rows 1 & 2 are merged as these are the headers, these rows doesn't require to highlight duplicates. Also, column O has formula and is being removed when I run this code.