conditional formatting across worksheets

[jcavigli]

Hello,

I am having a problem. So, I will post a somewhat trivial example - but it would be of great use to me.

I have a workbook with two worksheets. The first worksheet is called 'Enter Data Here' and a person can write in OR paste a list of names in column A. I would like to conditionally format this column of data.

1- If the name written in OR pasted in is apart of the 'Accepted Names' column on the 2nd worksheet then the color should be GREEN.
2- If the name written in OR pasted in is NOT apart of the 'Accepted Names' column on the 2nd worksheet then the color should be RED.

Attached is a sample. I think it makes what I am trying to say much easier to understand.

Thank you in advance for any help.