Forum Discussion

Fayes1987's avatar
Fayes1987
Copper Contributor
Jan 19, 2024
Solved

Conditional Formatting for training matrix

I'm so confused. I have a training matrix for work skills. Names in the first column, then each of the columns has the skills, manual handling, first aid etc. I want to type in the date that the st...
excel
Formulas and Functions
office 365
  • HansVogelaar's avatar
    HansVogelaar
    Jan 22, 2024

    Fayes1987 

    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.

HansVogelaar's avatar
HansVogelaar
MVP
Jan 22, 2024

Fayes1987 

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.

noushad1ali2000's avatar
noushad1ali2000
Copper Contributor
Dec 16, 2024

How to update monthly course completed data in the metrix to veiw and reminde to the next, any automated way

  • noushad1ali2000's avatar
    noushad1ali2000
    Copper Contributor
    Jan 19, 2025

    Greetings,

    Thanks to all of you for your suggestion and contributions on my development. 

    I have created an excel macro-based tool which pick the extracted current dates file from the folder and update all the dates as per emp code and its course code and then conditional formatting as mentioned above

    Thanks to all

    Appreciated

    Regards

    Naushad Ali

Resources