Forum Discussion
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 m...
You may use rule formula like
=(A1>=TODAY())*(A1<=EDATE(TODAY(),2))
for two months, etc.