Conditional Formatting With Dates

Copper Contributor

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:

MKLNLL_0-1660817324914.png

 

3 Replies

@MKLNLL 

=$B2>$A2

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

cf.JPG

 

@OliverScheurich 

 

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

 

MKLNLL_0-1660819782720.png

MKLNLL_1-1660819879515.png

 

@MKLNLL 

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