Forum Discussion
Re: Conditional Formatting for Date Occurring 2 Weeks (not days) in the Future
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"?
2 Replies
MSM182 Correct. You have to use the Column letter for the specific column you're working in. I've attached a copy of the original spreadsheet that @Patrick2788 was so kind to create for me and I added my own Column for you to see examples of Conditional Formatting with an Excel provided template date (like Today and Next Week) along with following weeks using the formula @Patrick2788 provided. My column has Today, Next Week, and then Weeks 2-8 in the future. I included a Color Legend because that's helpful to see at-a-glance. NOTE: @Patrick2788 provided a cell range in his example for the "Applies to" area. However, I used the entire Column (in my case "=$D:$D") in the "Applies to" area. Another difference: His formula references A2, which has a date entered. Conversely, my formula references D1, which is just text. This proves that you don't necessarily have to have a Date entered in your reference cell. It works both ways.
In conditional formatting rule formula for the reference you shall use first cell of the range to which the rule is applied.
