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

There is a date in January, which is still showing green

Answer 2

I have double checked that, but the cell format is for a date

Answer 3

Though cell format is date format, if it is a text. It can not be change to date value.

You may need to set date format first, then enter a date in that cell. Then it will be recognized as a date.

You may try reinputting a date.

Answer 4

It is caused by your data in that cell is text instead of date.

You may try reinputting the date and it will work.

Answer 5

Thanks I've deleted the data and re-entered it, but it is now showing red, and not orange