Hi,
Looking to create a formula return a text and format based on another cells date, but with 3 outcomes, I can only work in 2 based on the IF funcation.
I need the formula to do all of the following in one cell
If the date is less than today + 84 days then I want the cell to say BLUE and...