Search and highlight cells in sheet 1 with same content of sheet 2 (Inputsheet)

[Yoshii]

Hi.

I would need some help from you guys to solve this problem for me.
I have two worksheets in my workbook. In the first worksheet I have all kinds of data each row contains an ID number. And in the second I have a list of ID-Numbers. I would want to be able to make some kind of loop where it runs true the whole list of ID-Numbers in sheet nr 2 and looks for its duplicates in sheet 1, and when it found it could highlight the whole row.

 

[hiker95]

Yoshii,

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?

To start off, and, so that we can get it right on the first try:

Can you post screenshots of the two actual raw data worksheets?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post a small screen shot (NOT a graphic, or, picture, or, flat text) try one of the following:

MrExcel HTML Maker
If you do not know how to install and how to use HTML Mr.Excel Maker
https://www.youtube.com/watch?v=JycvgGppxt0&feature=youtu.be

Excel Jeanie
Download

Borders-Copy-Paste
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045

To test the above:
Test Here


Or, you can upload your workbook to (the BLUE link-->) Box Net ,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.