Forum Discussion

Laura87's avatar
Laura87
Copper Contributor
Dec 22, 2023

Conditional formatting - highlight dates due in 90 days not working

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?

 

Resources