Dec 10 2018 12:42 PM
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
Dec 10 2018 01:24 PM
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