hi how can i apply this but based on days passed.
1 days old =GREEN
2 days old= yellow
3days=orange
4 days=red.
i tried using this formula in the color cell for font but it only changes it to red. I must have something wrong. Please help. If(ThisItem.'ARRIVAL DATE.'<=Today()+1,RGBA(249,31,38,1),ThisItem.'ARRIVAL DATE.'>=Today()-2,RGBA(44,210,47,1),ThisItem.'ARRIVAL DATE.'<=Today()-3&&ThisItem.'ARRIVAL DATE.'>=Today()-4,RGBA(232,225,27,1),ThisItem.'ARRIVAL DATE.'>Today()-5,RGBA(249,132,31,1))