Hi there,
I searched for ages and cannot come up with an answer whereby I have a range of cells (D3<M110) and i want to highlight the duplicates but for the first match make the highlight a seperate colour.

I can do this using two seperate conditions
a) for one column (D) using;
=IF(COUNTIF($D:$D,$D1)>1,COUNTIF($D$1:$D1,$D1)=1)
=IF(COUNTIF($D:$D,$D1)>1,COUNTIF($D$1:$D1,$D1)>1)

but when I try
b) for a range (D3>M110) uisng;
=IF(COUNTIF($D$3:$M$110,D3)>1,COUNTIF($D$3:$M$110,D3)=1)
=IF(COUNTIF($D$3:$M$110,D3)>1,COUNTIF($D$3:$M$110,D3)>1)

It highlights all the duplicates, and the condition that should seperate the first match does not work.

Can anybody help?