Thanks Mike,
this has indeed highlighted some cells, but strangely the numbers
highlighted are not duplicates. There first four digits are the same but the
rest are different. effectively this means that the formula is deleting
numbers with same area code....curious

"Mike H" wrote:

Hi,

Select your range then add this conditional format
=COUNTIF($A$1:$A$100,A1)1
and select a colour

Note that in this Case A1 is the top cell of the range so change to suit.

Mike


"Paul B" wrote:

I don't want to delete them straight away as I found that the new remove
duplicates function has removed entries which were not exact duplicates