VBA code to recognize a range of dates.

Hey there!

I have been playing with a code that I have that searched through a table and found blanks contained within a certain column and emailed the appropriate recipients. However I am trying to change it in such a way for my table of certifications. My staff has to maintain unexpired certifications/licensing and my table allows me to do that. Right now, the dates are conditionally formatting to turn yellow when the expiration is within 90 days and red within 30 days. I would like the code to instead of read(searching) for blanks to recognize those data ranges instead.

I'm caught on how to turn it from conditional format to vba.

Thanks!

Post example workbook with dummy data
Cheers

View attachment Book1.xlsx

Further explanation of workbook, names in column a, email addresses in column b, certification d, f, g, h, i. "Status" in column E is where I'd like an sent on mm-dd-yyyy if possible. I will able the code for which certification with the use of a button but would like two separate ones for 30 days out and 90 days out. (30 in red, 90 in yellow)