Forum Discussion
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 ...
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