SOLVED

# Conditional formatting based on difference of two dates

Copper Contributor

# Conditional formatting based on difference of two dates

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.

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

# Re: Conditional formatting based on difference of two dates

Conditional formatting rule formula could be like

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

# Re: Conditional formatting based on difference of two dates

@SergeiBaklan Thank you, that worked! You just probably saved me from mental breakdown 😄

# Re: Conditional formatting based on difference of two dates

@Vojtch575 , you are welcome

# Re: Conditional formatting based on difference of two dates

This is *almost* what I'm needing, but I need it in days, not months. How would I enter that formula?

# Re: Conditional formatting based on difference of two dates

Depends on what exactly you'd like to highlight. For example

``=TODAY()-\$A1 > 20``

to highlight dates which are more than 20 days in past.

1 best response

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

# Re: Conditional formatting based on difference of two dates

Conditional formatting rule formula could be like

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