Good Day,

I have created a spreadsheet to track training for the individuals assigned to my office. I looked at some of the post, but was unable to figure out how to make the formulas apply to what I need.

Cell A1 is the current date
Cell D5 is the current training date
Cell E5 is the training due date, with a formula that let's me know when the next training is due

I would like Cell E5 to turn yellow when the training is 182 days from the due date, and turn yellow when it is over due (366 days). Any help would be greatly appreciated, thank you in advance.