Aug 18 2022 03:09 AM
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
Any help is welcome.
Example:
Aug 18 2022 03:13 AM
=$B2>$A2
You can try this rule for conditional formatting. The formatting is applied to this range: =$B$2:$B$17
Aug 18 2022 03:51 AM
Aug 18 2022 04:16 AM
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?