Highlight/Identify Newly pasted/added rows

Hi experts!

Is there an easy way for me to determine the rows that I paste on an existing excel worksheet? Say for example, I have data from A1 to A100, then I added additional 50 so it makes my data to cover A1 to A150, but there are data from the additional 50 that is already included on the first 100, so I have to remove the duplicates as well. Sorry if this is a little bit confusing.

Hi Mark,

Use Below mentioned points
Select entire row
Conditional Formating->highlight cells rules->Duplicate Values

Thanks for taking some time to check on my post. Is there any way for this to be put into macro/vba?