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​

 

[kweaver]

(1) please modify your profile to reflect what version of Excel you run and
(2) would you provide a variety of examples rather than just 1?

 

[RudeBoy]

(1) please modify your profile to reflect what version of Excel you run and
(2) would you provide a variety of examples rather than just 1?

2003 Excel

SportingNews.com Fantasy Source - NFL

TEAM EVENT	32nd Place		TEAM EVENT	32nd Place
NO MAS PALITOS	2402​		Yo-Yo & The GUYS	2402​

These are bowling team names in this case we had a tie at 2402

 

[kweaver]

So, the ties are only considered for columns B and E?

 

[kweaver]

I selected B2:B21 and E2:E21, for example, then used this Conditional Formatting:

=COUNTIF($A2:$E2,$B2)>1

 

[RudeBoy]

I selected B2:B21 and E2:E21, for example, then used this Conditional Formatting:

=COUNTIF($A2:$E2,$B2)>1

Actually Columns C, G & K

So should I select those columns C-G-K & then hit Conditional Formatting and then I would select Use a Formula to determine which cell to format?

I would then enter in the Format values where this formula is true:

Let me know thanks for your help - Stay Safe

 

[kweaver]

That's why I asked for more than 1 example. You haven't shown columns G nor K.

 

[RudeBoy]

Here is a pic of em

 

[RudeBoy]

That's why I asked for more than 1 example. You haven't shown columns G nor K.

here you go

 

[kweaver]

It seems like the cell references change every time you send a sample.

If you select the C column, the conditional format might look like this:

=COUNTIF($C2:$K2,$C2)>1

When you select the G column, change the formula above from the 2nd $C2 to $G2.
When you select the K column, change the formula above from the 2nd $C2 to $K2.

or