No Success I'm afraid.

Still has the same results.

Can I use formatting on both conditions?

Sam.D

"Max" wrote:

Try this as the CF formula for the dual condition:
=AND(COUNTIF($N:$N,A2),A2<N2)
Success? celebrate it, hit the YES below
--
Max
Singapore
---
"Sam.D" wrote:
Thanks,

Unfortunately this highlights all duplicates. I only need the duplicates
highlighted when they do not report directly into themselves as in when what
is in row A does not match row N.

Sorry for my vague explanation.

Sam.D