Forum Discussion

Vojtch575's avatar
Vojtch575
Copper Contributor
Feb 28, 2024
Solved

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...
  • SergeiBaklan's avatar
    Feb 28, 2024

    Vojtch575 

    Conditional formatting rule formula could be like

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