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.

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
Note: the column should be min of 100 lines
the result should show:Highlight 250,-100,-100,-25,-25 , as there sum =0
100
250
-100
-100
-25
-25


Hope to see a reply soon ....