SOLVED

Formula for Conditional Formatting Dates

Copper Contributor

Hello, Everyone.  How do I create conditional color formatting for dates that fall in the following ranges: next 45 days (red); next 46-120 days (yellow); beyond 120 days (green); date in the past (grey)?

1 Reply
best response confirmed by AS2021 (Copper Contributor)
Solution

@AS2021 

 

Assuming the first cell in the range you want to format is A1, try:

grey =A1<today()

green = A1-today()>120)

yellow =A1-today()>45

red =A1>today()

Also, check the box "stop if true".

1 best response

Accepted Solutions
best response confirmed by AS2021 (Copper Contributor)
Solution

@AS2021 

 

Assuming the first cell in the range you want to format is A1, try:

grey =A1<today()

green = A1-today()>120)

yellow =A1-today()>45

red =A1>today()

Also, check the box "stop if true".

View solution in original post