One to One Formula extract then one to many

Just tried this and it did not hightlight or identify the 86 -86 And i was hoping this could be written in VBA because my master spreadsheet is 30,000 lines.

So the first macro will run a similar equation stating when the operation is the same t match one for one like 86.00 and -86.00 and mark it with a 1 in column AB and highlight the amount green
then
A second macro will run and state in same operation exclude the data that is marked with a 1 in AB and sum all other data that total to zero and mark the amount green and with a "2" in AB as well

So at then end when the macro finishes i can sort by column AB by 1 and 2 and i should have all data that ties to zero or i can filter by the amount column by Green and find all that net to zero as well

Ok i can agree with that statement . With that being said, we are 90% there. When you filter by AB the "1" it does show all the things that match one to one. And when you filter by "2" there is a 720.86 variance It grabs a lot but it seems to grab operation that may have only had one value so it came thru and other things as well. Is there a way to not have those come thru. For example i highlighted some. Is there a way to make those not come thru and that will be that 10%