Forum Discussion
Solved
Conditional Formatting for Date Occurring 2 Weeks (not days) in the Future
I'm using Office 365 and I have a column of dates that are sorted in ascending order (recent date on top). In Conditional Formatting\Highlight Cell Rules\A Date Occurring section, there are three pr...
SWB_MTC I tried your exact formula, and when I enter a date in a cell, the cell above it gets highlighted, not the cell I need. What is the cause of that?
Do I need to change "A2" to which column my cell is on, for example "M"?
In conditional formatting rule formula for the reference you shall use first cell of the range to which the rule is applied.