Conditional Formatting Logic Errors

Hi everyone,

So, I'm working on a project for work and I cannot get the conditional formatting correct. I've attempted this code:

=IF(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))>DATE(YEAR(B20),MONTH(B20),DAY(B20)),TRUE,FALSE)

So, we have timelines and I'm trying to format each cell to highlight yellow and then red and it gets closer to the expiration date. Using Instr A as the example. Once we have an established date (DAID) we have 120 days to perform an evaluation. So, under Initial for Instr A I wanted to create a formula based a 2/13/2009 that would remain blank until I populated a date. In the meantime @ 90 days from DAID highlight yellow through 120 days. After 120 days I wanted it to turn red.

30-day cell. We have +/- 5 duty days to complete another eval based on the initial cell.
60-day cell. We have +/- 5 duty days to complete another eval based on the 30-day cell.
90-day cell. We have +/- 5 duty days to complete another eval based on the 60-day cell.
Annual cell. We have +/- 5 duty days to comple another eval based on initial (every 365).

INSTR DAID INITIAL 30-DAY 60-DAY 90-DAY ANNUAL LAST NO-NOTICE
A 2/13/2009
B 5/4/2012
C 5/10/2010
D 6/8/2009
E 9/5/2012
F 8/12/2011
G 1/4/2013
H 11/8/2010
I 6/12/2012
J 11/16/2012

I've been working this for nearly 9 hours and I'm stumped! I could really use some help with this. thank you!

Matthew

Thank you Norie. I tried that one too and I couldn't get it work.

Chemist. I included a sample that should be easier to interpret. I added notes to the requirements.

Kevin,

I tried that format; however, the color will not adjust.

=DATE(2012,5,12) Cell B3 and Condition Format Cell C3 =B3-TODAY()<=90

Norie, on the full database it's B20 but for my sample it would be something like B2