finding duplicate column D

hi,

I am trying to get the following macro, to read column D and highlight any rows, which contain duplicate cells from column D.

Please view the attachment for further details, as to what the output should look like, when there is duplicate in column D.
test1.xlsx

The below code is throwing back a run-time error 9. I am little unclear what is causing this behavior.
Please advice further, if possible.

Please Login or Register  to view this content.

Many thanks

Thank you very much for your great help. The code works great

i would like to request, if it would be possible highlight the entire row, instead of the duplicate cells in column D.

Thank you for your time & help.

Thank you for updating the code. The macro works great.
Thank you very much for all your help and time.