I have a question about conditional formatting.

I have 2 sheets in the same workbook. One is titled "Paste Oldest Here" and the other is titled "Paste Newest Here".

Each sheet has 6 columns of data.

I am looking for a way to highlight an entire rows in "Paste Newest Here" when the ID number in Row A on this sheet IS NOT found in "Past Oldest Here" Row A.

Basically, I just need to highlight the NON DUPLICATES on "Paste Newest Here" when compared to "Paste Oldest Here".

There are a few blanks and I would like this formatting to happen without having to sort prior.

Your assistance would be greatly appreciated as usual!