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...
Try the following rules. See the attached file.
=AND(C3>=TODAY(),C3<=EDATE(TODAY(),3)) =AND(C3<TODAY(),C3<>"")
Try the following rules. See the attached file.
=AND(C3>=TODAY(),C3<=EDATE(TODAY(),3))
=AND(C3<TODAY(),C3<>"")