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

Dear Sir,

Thank you for the response.

The code is working perfectly.

But only if i type "completed" it reflects in all other sheets.

I need to get whatever i type against the part in the status.

For example, if i type "Work in Progress", same has to reflect for repeating part numbers against status column of all sheets.

Is it possible? And how is the repeating numbers highlighted in all sheets? You have added that also inside the code?

Thank you so much!

Regards,
Prasanna.A

Dear Sir,

Thank you so much. Everything is perfect except one thing.

The numbers which are in 1st sheet, if i type in the status column, it gets updated. This is 100% fine.

But there are few part numbers which are not in first sheet, but available in 2nd, 3rd and so on sheets.

In this case, I update the status column of the part number in second sheet and it has to reflect in all other sheets.

Basically if i update the status column against a part number in ANY SHEET, it has to update in all other sheets where it is repeated.

Is it possible to do?

Regards,
Prasanna.A

Hi,

Just I checked. It is working perfectly.

Thank you so much. It was a great help!

Regards,
Prasanna.A