Color Cell if range values

M

Michael

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
VBA Coding Help for Beginner 0
WorksheetFunction.Match Usage? 9
Development combinations with exclusion of columns 0
Development combinations with exclusion of columns 0
Create if partial match then copy and paste data from one cell to another 1
Macro help 0
Use BeforeDoubleClick to place 1 or 4 character in a cell 1

Top