Apply Conditional Formatting for Duplicate Numbers Based on Another Column's Criteria

Hello there,

I am trying to come up with formula in conditional formatting that will highlight duplicate numbers, BOTH positive and negative. However, I need duplicate values highlighted only if they both have the same code in column A. In other words, I don't want "72,000" to be highlighted in the section where column A is "331011.5" because it shows up only once even though this number shows up in section 331011.2. This is hard for me to explain, so please let me know if I need to expand on anything.

Below is the formula I currently have, but it is not working for me. Also below is a screenshot of my data.

=SUMPRODUCT(N(ABS(H1)=ABS($H$1:$H$10000)*($A$1:$A$10000<>"")*($A$1:$A$10000=A1)))>1

Capture.PNG

Hello,

Thanks for the advice, I will definitely do that moving forward.

Plugging in your formula gives me the error that there are too many arguments, so I took out "ABS" after countifs and it works that way. I do have a question about the way you structured your formula: how is the range ($H$1:$H$1000) a criteria in the countifs formula? I thought it is a range? Again, your formula worked without "ABS" but I am curious as to how it did.

Thanks for the help!