Hi,
can someone kindly take a look at this code and figure out why it will not work properly.

It is supposed to format individual cells from one range the same background color as matching cells of another range.

And if a cell from the first range matches two or more cells from the second range, then that cell is formatted black (white font).

Also, AC2 contains a margin value that specifies how far apart ('+' or '-') each value can be from each other (ie. +/-1, +/-1.5, +/-2, etc.).

I really appreciate any help.