Sandip,

An easy way to group opposite numbers is to use a helper column. Lets' say you numbers are in column C. In cell D2, use the
formula =ABS(C2) and copy it down to match your numbers. Then sort your entire table based on column D to bring "opposites"
together. If you want to find pairs of opposites, you could then use another helper column: in E2, use the formula
=OR(C1+C2=0,C2+C3=0)
and copy down to match your data. Then filter your entire table on column E, showing only TRUE.

HTH,
Bernie
Excel MVP


"Sandip Shah" wrote in message om...
Hi,

I have dowloaded an account details from my accounting package into
excel. The number of transactions runs into over 10000 lines. All the
debits and credits ( positive and negative ) numbers are in the same
column.

Is there a way through a macro or a function where I can highlight one
set of postive and negative number appearing in the list. Thus all the
numbers with the offset entry ( opposite sign ) should be highlighted.

For eg. If 100 is there on one row, and -100 on some other row (same
coloumn), both these numbers should get highlighted. Incase there is
another 100 with no offseting negative entry, it should remain
unhighlighted.

Your help would be appreciated.

Thanks
Sandip