Remove Duplicates and Locate only Newly inserted Datas

Here I copy new data and inserting in the old data previous rows now I have remove duplicate means 1 and 6 will be removed down it is ok but I want to find that newly inserted data how will I do that ? Say simple idea with easy formula and without formula (color option)