Conditional Formatting

[daithi_ie]

Hi,

I hope someone can help as I'm trying to get a workable solution to this without too much luck so far.

I have a number of competitions taking place and I want to highlight all competitors who are entered into a competition more than once. In the example below, Grace (A1 and A2) is entered twice into the Masters class (Column D) on different horses (Column B).

What formula could I use to conditionally format (Column D) for any competitor in the table who is entered into a competition more than once? I have a sample below but the table I'm working with has over 10 classes and 300 competitors.

Thanks

D

Competitor	Horse	Club	Competition
Grace	Apollo	Liverpool	Masters
Grace	Trigger	Liverpool	Masters
Helen	Kitty	Brighton	Starters
James	King	Manchester	Masters
Ger	Cruise	Newcastle	Starters

 

[AhoyNC]

Select your range in column D.
Then Conditional Formatting
Cells Rules
Duplicates