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 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 

excel

1 Reply

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    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