How do I compare two lists of numbers?

I have a long list of numbers in two columns. I want to find out what
numbers are in column A that are not in column B. Is it possible to use
conditional formatting to do that?

Yes, Select column A, and use a formula of

=COUNTIF($B:$B,A1)=0

--

HTH

RP
(remove nothere from the email address if mailing direct)


"demebe123" <demebe123@discussions.microsoft.com> wrote in message
news:48CC0BC2-7CE6-42B0-8890-9E942FD35965@microsoft.com...
> I have a long list of numbers in two columns. I want to find out what
> numbers are in column A that are not in column B. Is it possible to use
> conditional formatting to do that?