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.
"cells 12months older than the date entered in them".
But that is relative to today's date, isn't it? Please explain.
Hi Hans, maybe I'm just getting a bit muddled up.
Its not dates that are 12months older than today.
So in this example Bob completed stock delivery training on the 16th of October 2023, This needs to change to due to expire ( yellow ) on the 16th of September and change to expired ( red)on 16th of October 2024.
Thank you for your assistance.
Faye Snushall
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 Hans, I'll give it another go.
