You could use conditional formatting with a formula of

=ISNUMBER(MATCH(-A1,A:A,0))

--

HTH

RP

"Ctech" wrote in
message ...

Im having a column with numbers... a lot of these number are exactly the
same except that they are negative/postive so the sum of them will be 0


is there any way I can make a macro which wil indetify to cells which
will qual eachother out to 0?


-1500
-1000
-1000
-200
-100
-30
20
30
99.5
1000
1500

on this list above, these numbers will equal each other out:

-1500 + 1500 = 0
-1000 + 1000 = 0
-30 + 30 = 0


All help apprichiated.


--
Ctech
------------------------------------------------------------------------
Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=501981