Conditional Formatting Formula based on length of expired date

Hi,

I'm creating a training register for my workplace and need help creating conditional formatting based on length passed certain date.

In columns C through to M I have the date that the training was completed. I need to create formulas for the below

Date entered is within the last 4 months (GREEN)
Date entered is 5+ months older (ORANGE)
Date entered is 6+ months older (RED)

Would love any assistance. Have tried some other suggestions on here for various other formulas but none have matched my criteria exactly (or worked with my guessed changes!)

Maybe try these formulas in Conditional formatting:

Red color
=AND(C4<>"",DATEDIF(C4,TODAY(),"M")>=6)

Orange color
=AND(C4<>"",DATEDIF(C4,TODAY(),"M")>=5)

Green color:
=DATEDIF(C4,TODAY(),"M")<4

See attached

Thanks so much - that seems to have *almost* worked. But it looks like the orange overrides the red (or the red overrides he orange, based on where I layer them within my rules). Do you know how to avoid this? I've attached the updated spreadsheet so you can see what i've done

Put the RED on one the top, like I had on the one I attached.

Got it, thanks again