Hey I've tried looking around here to solve this problem, but didn't find a solution. Basically I'm creating an excel spreadsheet covering names and dates of people who have taken online training courses that have to be retaken every year. I want the spreadsheet to change the colors of the cells based on how close the person's training qualification is about to expire. So far this is all I've come up with in conditional formatting...

If someone conducted training more than 11 1/2 months ago then the cell will turn red
=ROUND(NOW()-F1,0)>350

If someone If someone conducted training less than 11 months ago then the cell will turn green
=ROUND(NOW()-F1,0)<335

For some reason I can't get excel to accept a formula that will change the cell color to yellow if the person is in between 335 and 350 days.

Thanks