Symbol for Status


I am trying to create a formula using symbols (bubbles) to indicate "red" after a due date has reached, "yellow" when it reaches 90 days before the due date, "green" when it is more than 90 days before the due date. I used the following formula but the formula remains in the column instead of it changing to the symbol (bubble). The formula I used is:  =IF([Due Date] >= Today + 90, "Green", IF([Due Date] >= Today, "Yellow", "Red"))

Any help would be welcome.



Best Answers