Annual Expiration Conditional Format

I work in IT tracking various users certificates.

I have to sift through hundreds of users on excel looking at their expiration date, and manually selecting them from the filter list, and then copy them to a sheet so departments know to update the certificate.
I want a conditional format rule that simply says hey this user's certificate has expired exactly a year ago from today, make it red, and spit it out a copy of those users on another page.

Thanks in advance for the help!!!