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!
Bookmarks