Match Negative number with its corresponding positive number after matching columns

Hi,
I am looking to see if there is a way to highlight a negative number with its corresponding positive based on the information on the other columns. Here is an example:
Col 1 Col 2 Col 3
Apple Orange -1
Apple Orange 1
Apple Banana 1

So I want excel to compare column 1 and 2 and then highlight row 1 and 2 since there is a negative and corresponding positive number on there. I dont want excel to highlight it if the numbers dont match even if column 1 and 2 have an exact match. Does that make sense?

Hi Asharma9,

You can try to use this formula to conditionally format the cells:
=SUMPRODUCT(($A$1:$A3=$A1)*($B$1:$B3=$B1)*(($C$1:$C3=$C1)+($C$1:$C3=-$C1)))>1

Best regards,
Maarten

Hi All,
Thank you so much for your great suggestions. I am not exactly getting the right output yet. The other thing I want to achieve is that if there are multiple of the same combinations then I want to select only one combination of the negative and positive value.
Here is the Example again, I added another row of apple and orange with +1. I want to select only ONE combination of apple, orange -1 and apple, orange, +1. I want it to ignore the last one. Is that possible?

Col 1 Col 2 Col 3
Apple Orange -1
Apple Orange 1
Apple Banana 1
Apple orange 1

Thanks!
Amar

It works like a CHARM Ankur! Thank you so much for your help! You are a genius man!

Yes, my data was like that except it wasnt apple and Banana But were medications which were taken out and then returned back to the machine which created a positive and negative value.