Conditional Formatting With Dates

New Contributor



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


Any help is welcome.





3 Replies



You can try this rule for conditional formatting. The formatting is applied to this range: =$B$2:$B$17





Thank you for the response, but there is a malfunction, any ideas? 






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?

cf applies to range.JPG