Mark Cells if Match found in Sheet2

Hi all,
I have the below code that marks (turns bold and colored yellow) the Cells in Sheet1 (Column1) if there is a match on Sheet 2 (Column1).
It is working okay but I need some help to tweak it a bit.

Please Login or Register  to view this content.

Can you help me modify the code so it will loop and apply the same action to other columns in Sheet1?
I have many columns on my actual sheet (around 400) but for the purpose of demo, I have only added 5 columns on my example spreadsheet.
Sheet2 will not change, I only have 1 Column in this sheet (Only Column1)
I hope you can help me out. Thank you in advance.

Please Login or Register  to view this content.

..............................................
Thanks.gif