Compare two names list and compare other column aftrerwards

I have a Excel file with two sheets.

Both sheets have names on it - First name and Last Name. I need to compare the sheets to see if there are duplicates in the first sheet and if there is then find the value against the name in Sheet 2 - highlight the name in Sheet 1.

For example:

If Sheet 1 has a duplicate name as Sheet 2 and that name has the value Card in Sheet 2 then need to highlight that name in a particular colour otherwise another colour.

See attachement