compare two columns and highlight the matches

[assino]

Hello everyone


i'm searching how to Compare two columns and highlight matches
there is many different ways but what i want is to highlight one cell if there is only 1 cell that contains the same value on the other column
for example :
if there is 2 cells that contains "x" in column 1, and 3 "x" in column 2, i want to highlight two cells in each column,
what i want as result that the sum of highlighted cells in A = to the highlighted cells in B.

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff New.xlsm
	A	B
1
2	A	M
3	B	D
4	C	I
5	D	P
6	R	Q
7	F	R
8	G	S
9	R	T
10	I	I
11	J	D
12	D	W
13	L	X
Master

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B13	Expression	=COUNTIFS(B$2:$B2,B2)<=COUNTIFS(A$2:A$13,B2)	text	NO
A2:A13	Expression	=COUNTIFS(A$2:$A2,A2)<=COUNTIFS(B$2:B$13,A2)	text	NO

 

[assino]

Hi & welcome to MrExcel.
How about

+Fluff New.xlsm
	A	B
1
2	A	M
3	B	D
4	C	I
5	D	P
6	R	Q
7	F	R
8	G	S
9	R	T
10	I	I
11	J	D
12	D	W
13	L	X
Master

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B13	Expression	=COUNTIFS(B$2:$B2,B2)<=COUNTIFS(A$2:A$13,B2)	text	NO
A2:A13	Expression	=COUNTIFS(A$2:$A2,A2)<=COUNTIFS(B$2:B$13,A2)	text	NO

Hi,
thanks for replying that was very helpful

 

[Fluff]

You're welcome & thanks for the feedback.