Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Conditional formatting - highlight dates due in 90 days not working

Copper Contributor

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)

Laura87_0-1703247734300.png

 

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

 

2 Replies

@Laura87 

Perhaps

= cell value < TODAY() + 90

Thanks. That doesn't work either :pensive_face: