Deleting Duplicates

Hi there,

Please could you help me by writing a formula that will highlight duplicates. I want to use the supplier code (column D) as the search criteria.

Please can the formula identify these duplicates by entering the word 'duplicate' in column L.

Thanks in advance

Sam