Highlighting Non-Consecutive Duplicates

[Innoguide]

Does anybody have any suggestions on how to create a conditional rule that finds non-consecutive duplicates in a column of data (numbers or text)? For example, the data below have been highlighted (red text) showing the desired result. Note that all occurrences need to be formatted.

AB
AB
AB
ghy
ghy
ABCD
ABC
r
r
ghy
eee
eee

Any help would be greatly appreciated!

 

[Innoguide]

Here's another approach. Try this formula in conditional formatting

=MATCH(2,1/(A$2:A$13=A2))-MATCH(A2,A$2:A$13,0)<>COUNTIF(A$2:A$13,A2)-1

If there are any blanks in the range it won't format those

Nice addition Barry - Hadn't thought about blanks!