I'm trying to make a colour scale based on Today() between another entered date, basically a scale that starts green to yellow to red. I've attempted to try For green: =DAYS(TODAY(),$I2)=0, For Yellow : =DAYS(TODAY(),$I2)=105, For red: DAYS(TODAY(),$I2)=105DAYS(TODAY(),$I2)=150. $I2 being the cell where I entered the date a document was completed. Is there a way to do this, thank you very much in advance.
Conditional formatting rules are applied in the order they appear in the list. The first rule that evaluates to true will get applied, and the rest of the rules do not get evaluated nor applied.
Try these rules, in this order:
=today() - I2 >= 150
=today() - I2 >= 105
=today() - I2 >= 0
See this answer for an explanation of how date and time values work in spreadsheets.