How to send emails automatically based on conditional formatting values

Your are planninging to harness the cart to the horse. It isn't conditional formatting that can trigger the sending of an email. Instead, it's the conditions that control the formatting that can also be made to trigger other actions. To automatically send an email you would need to employ VBA.

In fact, once you have VBA examine your data for certain conditions I would recommend to use it for setting cell formats as well, including colours, because it brings more flexibility to the job, and more transparency, too.

Unfortunately, this is all the help this forum can offer you at this stage. Once you have some code that is doing the job - or trying to - we can help you improve it. We can also advise you on how to use specific functions of Excel or VBA which might challenge your knowledge once you settle down into programming.