VBA Macro to Send Email Reminder of Certification Expiration

Hello everyone,
Sorta new to VBA macros but love learning the ropes. If someone could help build the template for this and I would be able to learn and build so much more to VBA macros for all my excel sheets just from the source code template.
I don't know if all this is possible exactly, but 90% sure.

Excel version is Microsoft 365.

So in my excel file, I have a column for names, different certs 1,2,&3 etc, and emails.

Currently have conditional formatting in the cert dates as:
Green = Valid
Orange = 30 days from now
Red = Expired

I am trying to set up a way to send an email to a team member if his/her certification is about to expire in 30 days and to send an email to a team member if his/her certification is expired.

With the Subject, Body, and Text to be formulated from a separate sheet.

Preferably would like to execute a toggle button to preform these actions; that way it does not send the email out every time the file is opened as the file has to be accessed multiple times throughout the week.

For testing purposes, I'll have the email display(.Display) but in actual production, would like it to send(.Send) automatically.

Let me know of any other required information to help get this going.

Omg, this work flawlessly as I requested. Cannot thank you enough!

A quick possible change request in the end outcome.

Instead of the
"will expire in less than 30 days"
and
"has already expired"
is there any chance to have it read instead,
"will expire in (#) days"
and
"is (#) days expired."

I may want to change the variables down the road for what is red vs yellow and this will eliminate the "30 day" factor.

Thanks again nankw83!

Learning a lot just from studying and reviewing this code.

nankw83, thank you sooo much! I really appreciate your help in this.