Michael,

This can be done with Conditional Formatting (CF), I believe.

Select tempdb and make sure that A2 is the active cell. In CF enter Formula is
=COUNTIF(tempdb2,A2)

HTH
Anders Silvén

"Michael" skrev i meddelandet ...

I have a range of cells (a2:a1677) which I will call
tempdb. I have another range of cells (j2:j851) which I
will call tempdb2. I would to scan each individual cell
in tempdb (a2,a3,..a1677) with the range of values in
tempdb2, if the value is found to match the current cell
value in tempdb then color the cell red and move to the
next cell.

Thank You,

Michael