Hi all,

Wondered if anyone could help me please.

I've got a spreadsheet with a few worksheets in it. Each worksheet is updated daily. I want to be able to highlight cells that are not duplicated.

I've looked at conditional formatting, but it's not as straight forward as I hoped!

Example;

Sheet 1 - column v = a list of numbers
Sheet 2 - column a = a list of numbers

They should contain exactly the same numbers, although not always in the same order.

I would like to highlight anything on sheet 2 column a that does not appear on sheet 1 column v.

The problem is I'll be replacing all the data on sheet 2 and adding to sheet 1 daily.

Any guidance would be most welcome!