Hi,

Conditional formatting is the answer but you can't refer to another sheet
directly so assuming your data are in column A put this in b1 and drag down
to the same length as column A

=COUNTIF(Sheet2!A$1:$A$20,A1)0


Select column A data then

Format|Conditional format - Formula is and enter the formula

=B1=TRUE

Pick a colour - OK

You can hide the column with all the TRUE/False values in

Mike


"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