Macro To find match Value from other clomn and highlight in yellow

Dear All..Hope all is fine..

Format is hereby attached....FORMAT.xlsx

My work is to reconciol accounts..I need ur help to give me a macro to find the match number (Full or Last 4 digits) and highlight both of it. and also as per attached second sheet (if Possible) but first sheet is so important).

Note: I want to find part number in Column J from Coumn D..thanks
Thanks in advance.