Forum Discussion
Conditional Formatting for training matrix
Thanks for the clarification. That does depend on the current date: if Bob completed training on 16-Oct-2023, the cell should currently be green. But when the current date is 16-Sep-24 it should change to orange.
Create rules like this:
See the attached version.
Thanks for the clarification. That does depend on the current date: if Bob completed training on 16-Oct-2023, the cell should currently be green. But when the current date is 16-Sep-24 it should change to orange.
Create rules like this:
See the attached version.
This is exactly what I’m currently trying to do. I can do it on Excel (I use 365 at home), but I’m struggling to do this at on Excel via OneDrive at work. Any ideas?!
It should work the same way on OneDrive - what is the problem exactly?