Date expiry conditional formatting in Excel 2007 (I think it is the 2007 version anyway)

Hey all,

I am struggeling with getting my certificats expiry dates light up 2 years, 1 year; 6 months, ... before expiry and on expiry.
With this in the boxes. "- 2 years" in a green box. "-1 year" in a light green box. "- 6 months" in a yellow box, ...

See attached for my file. I tried with, the less then 2 years valid, but struggle with this pretty some. Tried so many codes so far in conditional formatting but not working all as should/hoped.

Hope anyone can help me out with this?

Thanks so much for the help in advance,

Nico