Forum Discussion
Conditional Formatting With Dates
Hi, I have a question with conditional formatting with dates in two lists. I would like to highlight list B if the date in list B is later then the date in the corresponding cell in list A ...
=$B2>$A2You can try this rule for conditional formatting. The formatting is applied to this range: =$B$2:$B$17
I assume it's because of the applies to range. Your rule for conditional formatting starts is row 13: =$T13>$S13
Therefore the applies to range has to start in row 13 as well. In the example i chose this applies to range (highlighted in yellow in the screenshot): =$T$13:$T$22
Which is the applies to range in your sheet?