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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try the responses in your later post ..
... and post some feedback to the responders over there
(This is a discussion group, not a dartboard)

---
 
Back
Top