Pulling Non-Duplicates Between Sheets

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!

Attached here.

Sheet 2 shows 1 in green as this is not on sheet 1. I want to automate that process.

Thanks, and which condition formatting will let me choose the name 'Range'?

That is highlighting just 3 cells. I've checked sheet one (Range) and they are all there, so should be all highlighted green?

Yes, yours is working perfectly, but getting that to work my spreadsheet is the issue!

This is exactly what I need, so I think you've answered my question - I just need to work that into what I've got.

Thanks for your help!!