I need conditional formatting that would highlight dates in my chart that are 1 year (green), 2 years(yellow), and 3 years+(Red), and missing dates(red). I want them to refer to a specific date like from Sept 1, or whatever date i choose. I have tried different things, none work. Any help would be appreciated.
Thanks!!
Kim