Forum Discussion

Shea_Bush's avatar
Shea_Bush
Copper Contributor
Dec 10, 2018

Colour coding through formula's

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 6...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 10, 2018

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

 

 

 

Resources