Colour coding through formula's

Copper Contributor

So I am looking to colour code different cell's based on their date.

Red - If the date has passed the current date

Orange - If it is 30 days from the current date

Yellow - If it's between 30 and 60 days from the current date

Green - If it's between 60 and 90 days from the current date

 All help is greatly appreciated <3 

1 Reply

You may apply conditional formatting rules to your range with formulas like

=A1>=TODAY()
=TODAY()-A1<0
=TODAY()-A1<30
=TODAY()-A1<60

in same sequence as your colors