Forum Discussion
Solved
Conditional Formatting
I am setting up a spreadsheet using various dates. I would like to set it up so it highlights cells if within a 2/3 month period prior and also highlight if it hits or passes the date. I've set it up before but am unable to remember how I did it. 🤦♀️🤦♀️
Try the following rules. See the attached file.
=AND(C3>=TODAY(),C3<=EDATE(TODAY(),3)) =AND(C3<TODAY(),C3<>"")
1 Reply
Try the following rules. See the attached file.
=AND(C3>=TODAY(),C3<=EDATE(TODAY(),3)) =AND(C3<TODAY(),C3<>"")