Contitioning Checkboxes to appear based on colour

[Alatar]

So I am creating a spreadsheet for use with training certificates.
After a period of time has elapsed person X needs to re-do or do a refresher on their certificates.
In the spread sheet, when a certificate date is 30 days away from expiring, the box turns yellow. Expired (todays date or greater) it turns red. Used conditional formatting for it.

Now what I want to do is have a check box appear inside of a cell that changes its colour. Date changes yellow or red > Check Box appears. The check box will be used to singnify if someone is "booked in to retrain" and that they have been contacted. If so, checkbox is marked by a human hand.

Once they re train, the date on their cert will be updated (say a year from now) and the box will turn back to the usual white automatically. At which point id like the check box to untick itself then remove itself or untick and hide until the date changes again.

I put a checkbox in every cell but I disliked it. Looked Cluttered

So is it possible to have a checkbox automatically put into a cell when it changes colour (yellow/red). Or have the checkboxes already there hidden, but "unhide" when the cell changes colour and "hide" when it goes back to white?

Thanks for your time and your help!

[nigelog]

This will give you an idea of how to organise

[Alatar]

?? I don't see checkboxes appearing when something turns red. I've no idea what i'm looking at

[nigelog]

There is a big button that says delete checkboxes. That will delete what is there. The button that says add checkboxes will add a checkbox to any row that is coloured red. It is actioned by workbook open so only needs to read the cell colour not the date which you have in your conditional formatting. Press contact allows you to action a method of contacting the individuals ie email.
If still unclear post a desanitised copy of your own workbook.