Please. Let's put all your conditions in the same terms.
Quote:
<90 days from the date's annual date will turn yellow
<60 days from the date's annual date will turn amber
<30-past due from the date's annual date will turn red
>91 days it will remain green
|
Y: CellDate<Today()+365-90
A: CellDate<Today()+365-60
R: CellDate<Today()+365+30
G: CellDate>Today()+91
Please verify these and we can proceed.