Highlight repeated cell in excel and update the text

Hi,

I have an excel with more than 20 sheets. There are 3 columns in each sheet. S.No, Part number and Status.
Each sheet has 50+ part numbers. These part numbers are repeated in different sheets also.

First thing i need to do is to highlight all repeated part numbers in all the sheets. I browsed though this forum and got code to do. But it highlights only in the current sheet and not all the sheets.

Second thing i need is, if i update the status column as "completed" against any part number, the status column against the same part number repeated at all the places in different sheets also should get updated as "completed"

Is it possible? I have attached excel for reference.

Thank you.

Regards,
Prasanna.A