match The values that are opposite and not equal

[satyakamnanda]

Hi ALL,

I am new to this forum. basically looking for a macro that would match the values that are opposite and not equal and also in the same column.
E;g: 100
250
-100
-100
-25
-25

Basically the values should match and the cell highlighted.
Hope to see a reply soon ....

 

[JackDanIce]

Welcome to the board.

Can you give a better example? What happens in this situation:

250
-100
-200
-100
-20
-30

How do you determine in above what matches and what doesn't?

What happens in this example:

250
-100
-200
-100

or:

240
-60
-60
-60
-60
-60

 

[satyakamnanda]

Hi Jack,

Apologise !! let me explain ..

I want that values , which are matched are highlighted. In other world , where the sum =0, then it should match all the relevent values and highlight's them