Each of your conditional formatting rules already has the formula necessary to determine the color. For example, if the training is required annually, the green formula could be something similar to =B5>today()-365.
To add a green percentage at the bottom in cell B26, you can use the corresponding array formula =COUNTIF(B5:B25,">"&TODAY()-365)/COUNT(B5:B25)