I am looking for away that will take allow me to highlight cells conditionally based on information from another sheet. I have cells containing names on one sheet. I would like to highlight that cell by having it look up the cell with the same name on another sheet and highlighting it based on a value in the column next to it.

For example I have the name B105 in a table of names in sheet 1. I want it to find B105 from another list on sheet 2 in column A and highlight the name in the table in sheet one based on a value in column B on sheet 2 beside B105.