Conditional formatting and differing time scales

Hello, I did have a similar question a couple of months ago and was given a solution that seemed to work. There was some conflict between answers so I would like a pretty robust solution to what I require. It is a training package which has many modules that require retraining at different timespans, ie one module may need retraining after 1 year but some modules can be as long as 5 years before retraining. So, a date has been inputted into a colleagues cell under one module and my aim is for it to remain unformatted until one month prior to the retraining deadline, then turn amber with that last month and if not retrained by the deadline to turn red. I tried adapting previous formulas but have failed to get satisfactory results.

Here is the link to my previous request Dates and conditional formatting I tried using "Cheeky Charlies" suggestion but it has failed me as have all the others. Any solid suggestions will be gratefully received.

SOLUTION

I was told that this is not accurate by another "informed" person but it seems to work by my testing. All I did was to change the highlighted values (-1 to -3 for a 3 year increment and -11 to -35 for one month less than the 3 years etc)

condition 1: value less than:
=DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY()))
format1:red
condition 2: value less than:
=DATE(YEAR(TODAY()),MONTH(TODAY())-11,DAY(TODAY()))
format2:orange

I hope this helps others that need similar solutions.