Solved: Finding and highlighting duplicate names

[owen_1987]

Hi all,

I have column A(which has names in) and I have been trying to design something that will find duplicate names in column A. What I need is a searching function that starts at A1 and searches column A, then offsets to the cell below and then search for a duplicate of that name etc etc. If it finds a name that is duplicates highlight the cell in yellow

The problem is the names are variable so I can't use a countif.

Can anyone help me with this please?

[Bob Phillips]

Select A2 down to the bottom, Use conditional formatting with a formula of

=COUNTIF($A$1:$A2,$A2)>1

[owen_1987]

thanks very much