Hi all,

I need a simple way to highlight all the numbers in a column which pair the exact negative and positive. However, the remove duplicate or the ASAP utilities highlight duplicate button just don't seem to do the trick. Reason it fail is it will highlight all duplicates.

In situation where I have two -1300 and one 1300. It will highlight all 3, where I just need them to highlight the first two cell that show -1300 and 1300 and leave the next -1300 alone.

Is it possible to do this just with conditional formatting instead of some funky macros?

Thanks,
Ray