Conditional formatting
I have been reading thread all day and trying different ones to see if they work for what I need, no luck.
OK, each cell will have a different date. I need the cells to automatically change colors when they reach one of the parameters.
<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
Please let me know if you need more information
|