I have 2 sheets in a workbook. On Sheet 1 I have a have a list of numbers call "fixed_by_maint". On Sheet 2 I have a bunch of number and other things associated with them. The column on Sheet 2 which contains the numbers is called "leaks_repaired". What I would like to do is delete all the ones on Sheet 2 that match any on Sheet 1. If not delete, at least highlight them. So if column A on Sheet 2 equals in Column B on Sheet 1, then delete or highlight. Thanks in advance