I have a draw being created that I need to identify when there are duplicate names in the row (b9:e9). I need to be aware when there is a duplicate in the row. In this example, Valerie Brown appears twice. Ideally, her name would be highlighted or have a different font colour. An alternative would simply be highlighting the whole cell when a duplicate is identified.
If anyone can help achieve this, that'd be fantastic and be much appreciated. My intention will be to copy this conditional format formula for subsequent rows so that each row identifies duplicates.
If anyone can help achieve this, that'd be fantastic and be much appreciated. My intention will be to copy this conditional format formula for subsequent rows so that each row identifies duplicates.
Nominations and Draw.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
7 | Court 1 | Court 2 | Court 3 | Court 4 | |||
8 | Opponents | Opponents | Opponents | Opponents | |||
9 | 3.30pm | John Black & Kevin White v William Yellow & Bob Purple | George Blue & Valerie Brown v Bruce Red & Jarrod Grey | Matthew Orange v Simon Rose | Sophie Mauve v Valerie Brown | ||
10 | 3.50pm | ||||||
11 | 4.10pm | ||||||
Draw |