Compare two sheets columns and if true change row color

Hi, and thanks for the assistance!

I need to compare each cell in Book_1 wooksheet under ITEMNO column to each cell in Book_2 worksheet under IDENTNO column
and if a cell is TRUE in Book_2, then select the compared row in Book_1 and change the row color to whatever, say yellow.

The reason I am doing this is I have a build to do and I want to compare the parts needed versus a master parts list of what is available in the building, so I know what I have to order off-site.
The above is my primary objective. However, I could go above and beyond and copy the location cell in Book_2 to column "G" in book_1 showing where the part is located.

Any help is, of course, greatly appreciated!
Thanks!!
Troy

You can do this with conditional formatting. Highlight A2:E7 and use the following CF formula:

=MATCH($B2,Book_2!$B:$B,0)>0

Pick your fill color and you're good to go.

To return the location, put the formula below in F2 of sheet 1 and copy it down:

=INDEX(Book_2!$E:$E,MATCH($B2,Book_2!$B:$B,0))

EDIT: For a cleaner version, use this:

=IFERROR(INDEX(Book_2!E:E,MATCH(B2,Book_2!B:B,0)),"")