sorry it does not fix it,
There are no cells with a red format like I set up

I also tried =IF(C2=C3,1,IF(C2=C1,1,""))
which works in another spreadsheet (numbers), but does not here for some
reason


"Bob Phillips" wrote:

There was a missing ) in my formula

=ISNUMBER(MATCH(C1,B:B,0))

does that fix it?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Filter by first letter"
wrote in message ...
Bob I did exactly what you ask - but I do not get any colour differential,
I
know for a fact that there are 200 names that are in both lists.
Very frustrated here

"Bob Phillips" wrote:

I would use conditional formatting.

Select all cells in column C, assuming starting at C1,
Goto FormatConditional Formatting
Change Condition1 to Formula Is
Add a formula of =ISNUMBER(MATCH(C1,B:B,0)
Select the pattern tab
Select a colour
OK out

all items in C that are also in B will show in colour.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Filter by first letter"
wrote in message
...
I have a list in column C that has thousands of different company
names
and I am trying to see which names in column C match up with the names
in
column B which has hundreds of names.