Highlighting duplicates of combined cells

[JanaD]

Hello,

I am trying to highlight all duplicated combination of 2 cells. Both cells are always numbers and I would like to see if there is already the same combination without adding a new column.
An example is:

20​	50​
20​	30​
20​	50​
15​	4​

I would therefore need Excel to highlight 1st and 3rd row as the combination exists more than once. I do not care whether cell A or B will be highlighted.
Thanks for any help.

 

[Fluff]

You can use conditional formatting for that.

Fluff.xlsm
	A	B
1
2	20	50
3	20	30
4	20	50
5	15	4
6
7
8
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:B10	Expression	=COUNTIFS($A:$A,$A2,$B:$B,$B2)>1	text	NO

 

[JanaD]

@Fluff perfect thank you.

 

[Fluff]

You're welcome & thanks for the feedback.