Improve a training register

Using Excel, the goal is to have a control of who is trained on a given training and color the cells as follows:
Current training: green
To expire in 30 days: Yellow
Over due training: Red
The spread sheet needs to be capable of updating the dates, deleting individuals and adding new individuals or new trainings.