Hi all,
I'm trying to conditionally format the below range to tell me if there are 2 identical numbers anywhere else in the range.
I just can't get my head around the appropriate formula
For example
The yellow highlighted cells shows what I want
The Red Groups are not what I want even though the the numbers are the same, they aren't "grouped"
Only the C&D, E&F, G&H, I&J, K&L, M&N Groups I am interested in please.