I think the OP also wanted to capture duplicates in the same column (although not in the example that's how I read their explanation).

If so you'll need to modify TMS's formula to this

=IF(OR(COUNTIFS($B:$B,$B2,$C:$C,$C2)>1,COUNTIFS($B:$B,$C2,$C:$C,$B2)),"Yes","No")