SOLVED

Conditional formatting based on difference of two dates

Copper Contributor

Hi, I guess this should be simple but I have been trying to figure out this for quite a while a cannot get it right.

 

I want to format a color of a cell (red) based on time passed between the date put in one cell (last time speaking with someone) and today. If the difference is larger than 18 months I want the cell to be colored.

 

thanks in advance!

3 Replies
best response confirmed by Vojtch575 (Copper Contributor)
Solution

@Vojtch575 

Conditional formatting rule formula could be like

=EDATE($A1,18) <= TODAY()

@Sergei Baklan Thank you, that worked! You just probably saved me from mental breakdown :D

1 best response

Accepted Solutions
best response confirmed by Vojtch575 (Copper Contributor)
Solution

@Vojtch575 

Conditional formatting rule formula could be like

=EDATE($A1,18) <= TODAY()

View solution in original post