how can I format sheet 1 if the value is found in sheet 2?

[Samad]

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

 

[Max]

Try the responses in your later post ..

 

[Max]

Try the responses in your later post ..
... and post some feedback to the responders over there
(This is a discussion group, not a dartboard)