change matched cells background color

Hi Guys,

Macro is not working

So the macro I am using is supposed to look back at all the months tab, match the Name from previous tabs and if they match change background color of the active sheet's cell to red.

Right now the macro is only able to lookup the name in the previous tab (i.e. For December it will only lookup November tab and not October-January).

e.g. (Candidate name is Jack King and he is in (october’s tab, Column A Cell 2 )
I want this candidate name to turn red once I type his name in November/December tab.

I have pasted the code I am using below

Any help would be appreciated.

Please Login or Register  to view this content.

You activate one sheet, the next one (previous is deactivated) and do on so finally only

Please Login or Register  to view this content.

is effective. Thus only November
and here

Please Login or Register  to view this content.

you (it condition is met) colour rcell (one of cells in ws12)
if you want to colour found cell change it into

Please Login or Register  to view this content.

so let's try to get closer to final version:

Please Login or Register  to view this content.

Add other months and check if it is working. If not - try to debug - may be there are some spell problems - no attachment to test code

Hi Kaper, Thank you for replying!

I tried your macro and it's partially working, it is making all the cells red.
I tried it in the December tab, Cells A3 and A14 shouldn't be red as those are't repeated elsewhere. I am attaching the excel workbook for your reference!

Hi, nawGo,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Ciao,
Holger

This shall work with previous months:

Please Login or Register  to view this content.

if you want to deal with all months call the above one in a loop like this:

Please Login or Register  to view this content.