ok this is how i did it
use a helper column and a vlookup formula back at sheet 2
=IF(VLOOKUP($G$11,Sheet2!$A$2:$A$8,1,FALSE)=A8,"fo und","")
so if employees name is found on sheet 2 this formula returns found on the
same row as the emplyees name
conditional formatting for this row is
=c8="found"
i had to change the formatting formula for each row,hopefully there is an
easy way!
--
paul

remove nospam for email addy!



"Samad" wrote:

If employee number 5263 found in sheet 2, show the raw in main data on sheet
1 in red, for instance.