, Good afternoon.
There will be 3
rules to apply the different colors as you wish.
: The current day is greater than or equal
to the 3 year term of the training completion date.
: The current day is less than or equal
to 30 days of expiration of the 3 year term of the training completion date.
: The current day is greater than
30 days from the expiration of the 3 year term of the training completion date.
I made an example by applying the rules of the desired conditional formatting.
I created a guide just to study separately the rules of each case.
Of course it can and should be deleted. It's just for didactic effect for you.
As you can see, there is currently no date that will appear a color other than green color.
So you just have to modify some date to see how it works.
Do some testing.
Was that what you wanted?
I hope I've helped.
Belo Horizonte, MG - Brasil