I need help with the following scenario. I have two worksheets that I need
to compare (Employee Name Column). One worksheet has 12,000 records and the
other one has 40 records. My goal is to be able to compare both and if a
name on worksheet 2 appears on worksheet 1 get some kind of alert or have
name highlighted.

I'm working with Excel 2007.