How can you set the color of a task bar to update based on another column such as "In progress, Not Started, etc". I saw another thread that has been closed but i am not able to see "Gantt/Calendar", I just see task bar. And when i apply the rule in conditional formatting it does not update in the gantt chart, it only updates in the calendar view.
I also only see this when i want to change the color of the Gantt task bar and cannot change the color.