Thanks John for you reply! I dont understand it though, probably I am doing
something wrong...Because nothing happens...although I do exactly what you
said..

"John Moore" wrote:

Try this .... column A relates to Old List, column B relates to New List in
this solution. Seleect the Old List range, click Format, Conditional format,
in the dialog box use the drop down list to choose "Formula Is", enter the
formula, COUNTIF(Newlist,A2)=0, click the format button and choose colour as
required ( say yellow ). Do the same for New List data but choose a different
colour.



"mariekek5" wrote:

Hi,

I see I am not the first one to ask this question, but I see some formula's
which work, but I would like to know why.

I used: =IF(ISNA(MATCH(A:A;B:B;0));"";INDEX(D:D;MATCH(A:A; B:B;0)))

But why D:D??

Well, what I would like to do is the following:

I have 2 columns with numbers, column A and column B. Say that B is the new
data/new version of the data. Some numbers will be gone (compared to column
A) and some numbers will be new (compared to column A). Is it possible to
make a fomula that shows me which number is new in column B and which number
is gone in column B, compared to column A?!

Thanks a lot in advance.

Marieke