Find The Match For All The Cells From A Range In Another Sheet And Use Their Color

[taccoo73]

Hi All;

Would like to thank you in advance for sparing your time and help.

What I would like to do is, to find the values of the cells from a range in Sheet1 within a range in Sheet2 and then use the background color of the matching cell in Sheet2 for the cell from Sheet1.

Here is the code I've tried with no success and my further attempts didn't work so far.

Please Login or Register  to view this content.

When I run the code above, all the cells in range from Sheet1 gets BLACK background color.

Best Regards;

Gokhan

[JBeaucaire]

Try this:

Please Login or Register  to view this content.

[taccoo73]

Thanks a lot for the prompt answer.

I've tried the code above but the result was the same. All the cells within the range ended up with black background color.

Best Regards;

tac

[JBeaucaire]

Would love to see this sheet where this is happening.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[taccoo73]

Here is the sheet. Thanks again for your time.

tac

[JBeaucaire]

My apologies... bad error:

Please Login or Register  to view this content.

[taccoo73]

Nope, my apologies for taking your time. Works like a charm. You're great, thanks a lot for the help.

Best Regards;

tac