Conditional formatting to highlight cells for due date in 90 days not working

Question

I have a training matrix setup which records training expiry dates, I have used conditional formatting to highlight cells which

• Are blank - training to be completed (yellow)
• Contain N/A (grey)
• Expiry is greater than todays date (green)
• Expiry is within 90 days of todays date (orange)
• Expiry is less than todays date (Red)

The formatting for 'due within 90 days' is not working, what do I need to fix?

Answer 1

>today()+90 Green

>today() Amber

<Today() Red

Answer 2

Thank you, but for some reason it's not working on mine

Answer 3

Could you point out which one?

Answer 4

Apologies, I've amended the formatting as suggested:

>today()+90 Green

>today() Amber

<Today() Red

But none of the due within 90 days (amber) are showing, everything is coming up either green or red.

Answer 5

You may try adding a date in Feb or march to test.

The earliest date in your table is May which is out of 90.