Help Conditional Formatting Formula

Please help me.

I am trying to create a training matrix with colour changing cells. The idea is the sheet will show the date the training was completed and then change colour as training needs to be redone so all training needs refreshing each year the cells will be green until 9months later then change to yellow and then change to red 1 month before training is due.

I have tried to complete this for the last two days and now I am loosing the will to live.


Jo
Please help !! attached is the sheet that is now the Bain of my life!!