When I have a Tie and the same number is referenced is there a way to change the color to RED?

[RudeBoy]

When I have a Tie and the same number is referenced is there a way to change the color to RED?
See below an example we had a tie 2477 sometimes we have multiple ties so wanted to know if I have a tie how can I have the tie number be turned to RED.

Example so If I have three people tied at 2477 then I would want to turn those ties number 2477 turned to RED. Thanks for your help

TEAM EVENT	20th Place		TEAM EVENT	20th Place
I GOT ONE		2477​		Ain't Got No Haters	2477​

 

[Fluff]

Try changing

Worksheets("Sheet3").Activate

to

Sheet3.Activate

 

[RudeBoy]

Try changing

Worksheets("Sheet3").Activate

to

Sheet3.Activate

I got this error - See picture attached

 

[kweaver]

Remove the word "worksheets"

 

[RudeBoy]

Remove the word "worksheets"

Ok I removed that and it saved it but how do I get it to execute on the sheet3?
Maybe my excel format is wrong? do I need to save as a .xlsm or something? I currently have it saved as a .xls

Let me know thanks stay safe

 

[kweaver]

Yes, definitely an xlsm because the "m" stands for "macro" which you have in the workbook.

 

[RudeBoy]

Yes, definitely an xlsm because the "m" stands for "macro" which you have in the workbook.

Looks like I can view code & go to ThisWorkbook and run/sub it and your code runs.
But when a change is made and the ties are not there then the cells that had originally been flagged as dupes stayed highlighted even after I ran the VBA?

If the Tie is gone the cell should reset to no highlight when I run the code.

I attached pic to show the tie gone but fields still highlighted after running vba

 

[kweaver]

Put this line after the Worksheets("Sheet3").Activate :

Sheet3.Cells.Interior.Color = xlNone

 

[RudeBoy]

Put this line after the Worksheets("Sheet3").Activate :

Sheet3.Cells.Interior.Color = xlNone

Thanks that worked