Match positive and negative values (with different assignments)

Hi all,

I am new to this forum but I have not yet found the answer to my question here.

I basically want to highlight amount -5000 and 5000 if they have the same assignment number. But I can't figure out a way to make this work properly. A big plus would also be if it's possible for the values -8000 and 7925 and 75 (with the same assignments) to be highlighted as well.

Is there any way you could have those functions to work properly? Please see the attached example.

Many thanks!

Best Regards,
Nicklas

You should be able to do this using conditional formatting.

http://www.homeandlearn.co.uk/excel2...l2007s6p2.html

Maybe I am slow but I cannot figure out how to make it work within only the same assignment. With both positive and negative values.

Originally Posted by xandermacleod

You should be able to do this using conditional formatting.

http://www.homeandlearn.co.uk/excel2...l2007s6p2.html

So the problem is that I only want the formula to search for the matching values within the same assignment (column A). So -5000 and 5000 should be highlighted (both with assingment 1) in the example.

I would be very happy if someone had a good solution for this.

Thank you!