I'm  all employee data in sheet 1,  in sheet 2 I'm using vlookup function to
retrieve employees for whom I issued certificates on a each day. My question
is, how I can mark those employees in sheet 1 for whom Ive already issued
certificates from those for whom I didn't. I tried conditional format
function, but it didn't work, as it is in the separate sheet.

Thank you for your help