Show duplicate values for combination and it's reverse version

[mrugesh]

I have 4 digit numbers in two columns. What I need to see is if the combination of them is being repeated below. So, if the number in column A is 1000 & column B is 1300, combination of them will be 10001300. Now I need to see if this combination or it's other reverse version (13001000) is repeating below or not.
Can someone please help me here?

 

[mrugesh]

No problem. Glad to help.

Hi Peter... Guess I jumped the gun. What you have given in conditional formatting works fine but is there any way to tweak it so that it keeps one instance unformatted & formats rest of the instances whether they are in regular or reverse order?

 

[Peter_SSs]

For the setup I showed earlier, change the CF formula to

=SUMPRODUCT(($A$2:$A2&$B$2:$B2=$A2&$B2)+($A$2:$A2&$B$2:$B2=$B2&$A2))/IF($A2=$B2,2,1)>1