Color Cells In a Worksheet Based on Values in Another Worksheet

Hi ExcelForums,

I have a workbook (attached) that has a worksheet called "Data". This work sheet has employee e-mail addresses, companies they've worked for and the urls for those companies. For example, [email protected] has worked for Google, AOL, and Sony.

What I want to do is color the employee e-mail address and the associated company and company url cells red in the "Data" worksheet if the employee's e-mail address is not in the "Employee Database" worksheet.

In the attached Color-Example.xlsx workbook I have a worksheet called "Desired Result" to exemplify what I mean. This is just an example, I have to do this with thousands of cells work of data.

How can I accomplish this? Is there a macro that can execute this?