Color cells if matching value exists

Hello all,

I am working on a vba code where I want cells A:K in a row to be colored if the matching value for cell A1 in active sheet is found on a list in a different workbook.

This is the code I came up with so far but I couldn't figure out how to tell it to proceed if matching value is found in range A1:A1000 in a different workbook. So far I can only manually plug in the value, but this is not what I want as I need it to find matching value on the list and color the cells.

Please Login or Register  to view this content.

I basically want it to find a matching value in column A range (lets say A1:A1000) and if found, to color the cells. If it doesn't find a match, he shouldn't do anything.

I need help adding stuff/rewriting this piece of code. Thanks!

Assuming that the other workbook is open use

Please Login or Register  to view this content.