Jul 21 2022 08:32 AM - edited Jul 21 2022 08:50 AM
I'm trying to make a formula that will change the color of the date to red if the date is older than 180 days from @now to Yellow if the date is older than 150 from @now and to Green if the date is less than 149 dates old.
I been trying lots of different formulas with no joy they only turn one color.
I tried modifying this one to do what i was but this one only those it to future dates no passed.
Jul 21 2022 11:17 AM