Mar 04 2021 09:36 AM
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)?
Mar 04 2021 10:00 AM
Solution
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".
Mar 04 2021 10:00 AM
Solution
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".