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

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

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

Try the responses in your later post ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Samad" wrote:
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

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

Try the responses in your later post ..
... and post some feedback to the responders over there
(This is a discussion group, not a dartboard)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---