Ok. I am desparate. I've working on this for hours;

I have VIN numbers in sheet 1 in the range I2:I5521

I have VIN numbers in sheet 2 in the range G2:G4717.

I need to see if the VIN numbers in sheet 2 are on sheet 1, of so highlight
the cell or delete the VIN number. I'd really like to delete the duplicate.