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