Cell to highlight different colors depending on the date in another cell?

[Gregwaa]

Is there away of for instance like a traffic light system where Cell A1 would highlight a different colour depending on the date in B1? For instance if the date is a week away from the present computer date A1 highlights Red, 3 Days away the cell highlights Orange and then the exact date Green?

[ragulduy]

You can use conditional formatting for this.
For example, add three conditional formats along the lines of:
=if(B1=Today(),True,False)
=if(and(B1>=Today()-3,B1<Today()),True,False)
=if(and(B1>=Today()-7,B1<Today()-3),True,False)
then assign the format on the first one to red, second one to orange and third one to green.

[Pepe Le Mokko]

Is there away of for instance like a traffic light system where Cell A1 would highlight a different colour depending on the date in B1? For instance if the date is a week away from the present computer date A1 highlights Red, 3 Days away the cell highlights Orange and then the exact date Green?

And what color should it be 4 5 or 6 days away, and 1 or 2 days away?

You can also use the built-in traffic light formatting once you have decided the above.

@youdlugar

CF implictly uses IF, TRUE and FALSE to determine the formatting. Fi your first condition can be =B1=Today() , the rest is redundant. Given the text box is rather short, how shorter the formula, how easier it is to edit