Conditional Formatting
 

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

Conditional Formatting
 

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

Conditional Formatting
 

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