I've tried out the conditional formatting and am unable to show different colored backgrounds for different future date conditions.
As an example: I want to show the date cell to show green if it is a future date with a Green Background UNLESS it is within 90 Days of Today's date. If that is the case, I want to show the background as Yellow.
Help Article Resources
Check out the Formula Handbook template!