Book Value: Bank numbers:
30 100
60 100
90 4.90
100 390
100 10
100 100
400 500
400 30
4.90 50
30 65

In Column A the book value, is there are way that I can get it to highlight when 2 or more numbers in Column B equal one of the numbers? Ex: 39+10=400 on the right.

In Column B the bank value, can I get it to highlight if there is a repeating number, but only once? for example the 100's, to only highlight once on the right?

Thanks! This is eating up my time at work, and I have so much to do!