Forum Discussion
Solved
Gantt Chart Conditional formatting
Hello,
I am trying to add a conditional formatting rule to my gantt chart within MS Project. Basically, I want the task bars within the Gantt chart section to be automatically highlighted in a different color if the tasks (with a finish date prior to "todays" date) are not 100% completed before "today's" date.
Could someone please advise how to achieve this?
This is Flag1's formula: Int( [Finish] ) < Int( now() ) And Not [% Complete] = 100
See the picture below in order to see how to define a new bar style controlled by Flag1.
1 Reply
This is Flag1's formula: Int( [Finish] ) < Int( now() ) And Not [% Complete] = 100
See the picture below in order to see how to define a new bar style controlled by Flag1.