Need cells from Worksheet1 to check corresponding cells in worksheet2 and respond

Hi guys,

This is my first post to the forum so i hope you guys can help me out!

What i need to do is have each individual cell in the range A1:J10 in my first worksheet check the value of their corresponding cell in worksheet2.
If the value returned is a 1 then the cell needs to be filled with the color black. If not it should just move on to the next cell.

So I've thought of just running each individual cell through an if statement to check it against its counterpart, but that seems like a very inefficient system to do so.

Is there some way such as using a while loop and increments to group this code into only a few lines?

Edit 1: This is a macro that i recorded. For some reason it doesn't work when i run it. If it did everything would be fine. (This is just in a test workbook so instead of fill i just wrote n in the cells that corresponded to a 1.)

Please Login or Register  to view this content.

Thanks in advance. If you need more clarification just ask.