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.


1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.