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!
Bookmarks