Formula to match negative and positive numbers

[JRAMZ88]

Hi everyone!

I'm working on a project where I need to match numbers regardless if they are positive or negative so as long as they have a pair...

I'm looking for a formula that will highlight the matches, but also ignore if there is more than one... shown below is an example.

Is that something someone here can help me with if possible? The data set is huge and doing manually is time consuming.

As always, appreciative of the feedback!
Thank you,

 

[KRice]

Try using conditional formatting as shown here. You don't need the B column formula...I included it to show the logic. The formula itself is entered into the Conditional Formatting window.

Book5
	A	B
1	1000	TRUE
2	-1000	TRUE
3	1200	FALSE
4	1500	TRUE
5	-1500	TRUE
6	1500	FALSE
7	2000	TRUE
8	-2000	TRUE
Sheet1

Cell Formulas
Range	Formula
B1:B8	B1	=AND(SUMPRODUCT(--(ABS(A$1:A$8)=ABS(A1)))>1,SUMPRODUCT(--(ABS(A$1:A1)=ABS(A1)))<3)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:A8	Expression	=AND(SUMPRODUCT(--(ABS(A$1:A$8)=ABS(A1)))>1,SUMPRODUCT(--(ABS(A$1:A1)=ABS(A1)))<3)	text	NO