Conditional Formatting

Kelsey 1 Reputation point
2022-06-06T23:15:58.003+00:00

Hi! I am hoping someone can help me create a formula that will help me track expiration dates.

I would like to write a formula that helps track a training expiration date without having the expiration date in the excel sheet. For example if someone completes a training on 03/01/21 and it expires in 3 years. I would like the cell to remain normal until 30 days before the training is due, once it hits 30 days I would like it to turn yellow and once it expires I would like it to turn red.

I have tried working on this for several days and haven't been able to find a solution. I would appreciate any help.

Thank you!

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,649 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. 瀧口　裕貴 1 Reputation point
    2022-06-07T01:10:06.21+00:00

    How about having the calculations in conditional format?
    How about entering the year and month and day separately, and then based on the year, +3 years will make any part of the line red, and (+3 years - 30 days) will make any part of the line yellow.