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

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

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