Thread: Conditional Functions for Gantt Chart

Hi,

I created a Gantt chart & able to get the bars to shade based on "planned" duration & using the following function, which seems to work well:

=AND($F12<=N$11,$H12>=M$11)

Now, on the same bar, I wish to add another shaded color or symbol to show "actual" duration.


How can I do this?

Thanks

Hi,

Does anyone have any suggestions on how I can add another type of conditional format on top of the existing one that I have?

I would like to show planned vs. actual & show actual either by a different color &/or use symbols.


Thanks