Conditional Formatting With Dates

Question

Hi,&nbsp;I have a question with conditional formatting with dates in two lists.&nbsp;&nbsp;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&nbsp;Any help is welcome.&nbsp;Example:&nbsp;

oliverscheurich · Answer

MKLNLL&nbsp;=$B2&gt;$A2You can try this rule for conditional formatting. The formatting is applied to this range:&nbsp;=$B$2:$B$17&nbsp;

mklnll · Answer

OliverScheurich&nbsp;&nbsp;Thank you for the response, but there is a malfunction, any ideas?&nbsp;&nbsp;&nbsp;

oliverscheurich · Answer

MKLNLL&nbsp;I assume it's because of the applies to range. Your rule for conditional formatting starts is row 13:&nbsp;=$T13&gt;$S13Therefore 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$22Which is the applies to range in your sheet?

Forum Discussion

Conditional Formatting With Dates

Share

Resources