Conditional Formatting Between Two Columns

Actually, I think the formula you need to use in teh 1st column is this...
=COUNTIF($A$4:$A$19, A4)>1
not this...
=COUNTIF(A4:A19, A4)>1
by the time you get to row 19, it has adjusted to this...
=COUNTIF(A19:A34, A19)>1

Regarding the next table, I dont see what you are trying to do?
A/1 appears 2 times and so does C/1, so why is A/1 highlighted and C/1 is not?
In fact, the only pairs that dont appear twice are E/2, A/2, A/3, B/2, D/2 and E/1

	H	I	J
3	GROUP	LEVEL	Count
4	A	1	2
5	B	1	2
6	C	1	2
7	D	1	2
8	E	2	1
9	F	1	2
10	A	1	2
11	A	2	1
12	A	3	1
13	B	1	2
14	B	2	1
15	C	1	2
16	D	1	2
17	D	2	1
18	E	1	1
19	F	1	2

J4=COUNTIFS($H$4:$H$19,H4,$I$4:$I$19,I4)
copied down

And maybe that is the formula you are looking for anyway?

Hi,

yoy could try as conditional formatting rule:

=(COUNTIF(A$4:A$19,A4)>1)*((COUNTIF(A$4:A$19,A4)>COUNTIFS(A$4:A$19,A4,B$4:B$19,B4)))


Regards

Edit:sorry FDibbins, I did not mean to overlap...

canapone, not a problem at all

The more answers we have, the bigger the chance the OP will find 1 they can use and understand
Besides, who's to say I read the question right in the 1st place? We have all see that different people interpret questions in different ways

OK, I think I understand. Use this as your rule...
=COUNTIFS($H$4:$H$19,H4,$I$4:$I$19,">1")

Thanks for the rep

Looks like my 2nd formula returns the same as canapone