Cell date and colour changes for expiring dates RRS feed

  • Question

  • Hello

    I am using Excel 365 and I have a spreadsheet that contains staff names, dates they achieved trainings and dates they completed tasks.

    When I input the date that the training/tasks were completed, I want to format the cell so that it automatically changes to the expiry date. 4 months, 6 months, 1 year, 2 years, 3 years. Also to change the cell green.
    I also want to change the colour of the cell to orange when they are 30 days within expiry date. Change to red when it has passed the expiry date.

    For example, Lisa completed training on 01/11/2020 that requires renewal in 2 years. When I input that date I want to automatically change to 01/11/2022 and change the cell green colour. When it is 01/10/2022, 30 days before the expiry date, I want the cell to change to orange. When it goes passed 01/10/2022, I want the cell to change to red.

    I tried looking online but was not understanding.

    If anyone could help, I would very much appreciate it.


    • Moved by Dave PatrickMVP Friday, November 6, 2020 12:51 PM looking for forum
    Friday, November 6, 2020 12:27 PM