There are 2 sheets in the attached spreadsheet. The 1st sheet, Weekly, has about 3,000 lines and I download this weekly. The 2nd sheet, Perm, are my numbers. I tried to use Conditional Formatting find duplicates, but I can’t get it to work. I need the Conditional formatting to find my number out of the almost 3,000 and then I will delete the other numbers.