Forum Discussion
JeffPeterson1
3 years agoQrew Captain
Try this in the formula for color-coding:
If(
Today() > [Closing Date], "purple",
Today() >= [Closing Date] - Days(7), "red",
Today() >= [Closing Date] - Days(30), "yellow"
)
------------------------------
Jeff Peterson
------------------------------