If you start in row 2

In cell A2
Or(A2=A1,A2=A3)



"Ann" wrote:

i have a single column of data. how do i highlight the duplicates in the
list. i've tried conditional formatting and can't get the formula right.
some rows might be duplicated 4 times and others just 2. tia