Match positive and negative values with the same assignment/reference

Hi all,

I want to match (highlight cells) positive and negative values per assignment. So in column A you have the assignment (ex. 1, 2, 3, 4 and 5), and in column B you have the values. So if the rows have the same assignment and have the values -5000 and 5000 they should get highlighted. But I cannot figure out any way to make this work properly with conditional formatting. But if there are two rows with the same assignment with the values of -5000 and 4000 they should not be highlighted. I have attached an example.
example.xlsx

Many thanks for your help, I hope this problem is possible to solve!

Best Regards,
Nicklas

In C2 enter the formula with Ctrl + Shift + Enter =SUM(IF($A$2:$A$11&ABS($B$2:$B$11)=A2&ABS(B2),1,0))

Then highlight your table A2:B11, select conditional formatting custom formula, and enter =$C2 = 2

In C2 enter the formula with Ctrl + Shift + Enter =SUM(IF($A$2:$A$11&ABS($B$2:$B$11)=A2&ABS(B2),1,0))

Then highlight your table A2:B11, select conditional formatting custom formula, and enter =$C2 = 2

You can use this conditional formatting formula

Formula:

=SUMPRODUCT(--($A$2:$A$11=$A2),-- ($B$2:$B$11=-$B2))

Does that work for you? See attachment