Forum Discussion
How to automatically change the cell color if the date is modified by a separate list of dates.
Hi, I have a list of dates that specific tasks must be completed by. If these specific task dates falls on a day that the company is closed, I have an equation that will automatically change the da...
Are the projects completion date based on the projects commencing date? What criteria is used to determine the completion date (7 days after the start date) ? You could add an conditional formatting, IF function that says something like IF(D4=,Your criteria+7) [green] and a second that says IF(D4<, Your criteria+7) [red] Make sure to check the box to stop if true next to the first condition.
As a comment, IF() is not necessary. =condition is enough.
Also in that case it's not necessary to check Stop Box. Conditional formatting stops evaluating rules for the cell on first rule which returns TRUE.