Suppose you have two workbooks Book1 and Book2 (unsaved) and names are in Col
A of both

In Col A cell B1 of Book2 enter the below formula which will return
"Present" if the name appears in Book1 Sheet1 Col A...

=IF(ISERROR(MATCH(A1,[Book1]Sheet1!A:A,0)),"","Present")

If this post helps click Yes
---------------
Jacob Skaria


"Nigel" wrote:

I'm sure I need conditional formatting, but I need some help. I have a column
of names in one spreadsheet and another column of names in a second
spreadsheet and I need to know if a name appears in both columns in both
spreadsheets.

Thanks