Project planner template and conditional formatting
Hello - i am using the MS project planner template and need help with the conditional formatting https://templates.office.com/en-us/Gantt-project-planner-TM02887601
From the template, the actual duration is not known, but the plan start, plan duration and actual start will be known. When my user updates the percent complete column, we want the conditional formatting to update the sections for plan duration, rather than rely on the actual duration being updated.
So for example
Plan start = 1
Plan duration = 10
Actual start = 1
Actual duration = blank
Percent complete = 50%
We would expect periods 1 to 5 to be dark purple as the project is in the plan duration and that 50% of it is done.
However if the period exceeds the plan duration, we would still need the % complete beyond plan to fill out with orange.
Is this possible at all? I am unfamiliar with conditional formatting fully as well as the name manager where all the formatting has its rules, and I have taken this role on in our company as someone as left and trying to assist as much as possible.
Posted Dec 16, 2019, 10:58 AM UTC