Forum Discussion

Allan Munro's avatar
Allan Munro
Copper Contributor
Jun 13, 2017

Conditonal formatting a date based on two cells

I have a sheet where I have a "due date" and "date completed".

 

I'm trying to get a formula whereby if the due date is passed by 30 days and the date complete cell is blank then the row will turn red.

 

Any advice?

Formulas & Functions
Need Help
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jun 13, 2017

    Hi Allan,

     

    If your due dates starts from A2 and days completed from B2 use the formula in rules

     

    =((TODAY()-$A2)>30)*ISBLANK($B2)

    and apply it to all your range, e.g. $A$2:$H$100

     

    Please take care about using absolute and relative references in above

     

Resources