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

Move the last rule to Top.

Answer 2

I have previously tried rearranging the order, but sadly this hasn't worked.

Moving it to the top colours all cells orange except for those which are blank or expired.

Answer 3

Could you share us a test file to reproduce your issue?

You may upload file in private message.

Answer 4

Move it to second one.

Answer 5

Thank you, however that also highlights dates beyond 90 days from today date, as an example 29/10/2024 is more than 89 days away, so this should be green.