Conditional formatting - highlight dates due in 90 days not working

[Laura87]

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?

[#2]

@Laura87 

Perhaps

= cell value < TODAY() + 90

[#3]

Thanks. That doesn't work either 😔