Forum Discussion
Kimberley Morton
Jun 21, 2018Copper Contributor
Conditional formatting help
I am trying to set up conditional formatting on some dates in excel without much success. I would like any date up to 2 months from today in green, any date more than 2 months in amber and any date more than 3 months in red. Can anyone help?
Thank you
1 Reply
Sort By
You may use rule formula like
=(A1>=TODAY())*(A1<=EDATE(TODAY(),2))
for two months, etc.