Hi. I have a table of registration numbers with dates of registration. In monitoring the numbers that failed to register this year, what I do is to copy the Registration sheet and delete all numbers registered prior to 2020 in the new sheet. Then I apply a conditional formatting in the Registration sheet to highlight those numbers that are not present in the 2020 sheet.


How do I effect the formatting right there in the Registration sheet without the hassle of creating another 2020 of current year sheet?
Thank you and sample file attached.

Attached Files

Registration.xlsx (11.9 KB, 13 views)