Hi!

Here's one option:

Use conditional formatting to highlight the numbers in column A that match
the DNC numbers in column B.

Assume the numbers in column A are in the range A1:A100. The numbers in
column B are in the range B1:B10.

Select the range A1:A100
Goto FormatConditional Formatting
Formula is: =ISNUMBER(MATCH(A1,B$1:B$10,0))
Click the Format button
Select the style(s) desired (maybe a different background color)
OK out

Biff

"Vindictiiv" wrote in message
...
I was wondering if anyone knew how to create a simple formula to show
matches
in phone numbers for a do not call type list. I have column A (my database
of
numbers), and I want to compare it to column B (the do not call list) and
report any matches in column C.