Conditional formatting based on linking two excel sheets by ID number? Save my career

Hi,

Please use the following formula in F3 in Book2.xlsx

=IF(VLOOKUP(B3,[Book1.xlsx]Sheet1!$A:$C,3,0)=D3,"Y","N")

Then use the conditional formatting D3=F3 to get the desired result.

Hope this helps..

Regards,
Chandraimage.jpg