Gantt Chart Help

[StevieG35]

I have a gantt chart that I like and understand how to update the information. What I am looking for is how to roll up all the sub task conditional formatting to the mask task line.

Example Gantt:

Start

End

Main Task

Y

Y

-

-

-

Y

Y

Y

-

-

-

Y

Y

Y

SubTask 1​

3/23/17

3/31/17

x

x

SubTask 2​

4/10/17

4/17/17

x

x

x

SubTask 3​

4/20/17

4/30/17

x

x

x

<tbody>
</tbody>

So I would like if there is conditional formatting on the Subtasks, for that to roll up to the main task. If you were to hide the subtasks you would still see a highlighted areas on all the dates on the main task.

X's are the conditional formatting for the subtasks
Y's would be the roll up of the sub tasks to the main task
-'s are blanks so no data would roll up there

 

[Worf]

Welcome to the Board

If rows 9 and 10 contain the sub tasks and row 8 is the main task, use a setup similar as the one below for the conditional formatting formulas.

Function translation: OU is OR, E is AND, DESLOC is OFFSET.


Sheet1 (2)

*	J
8	*
9	*
10	*

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:36px;"></colgroup><tbody>
</tbody>

Conditional formatting

Cell Nr.: / Condition Format J8 1. / Formula is =OU(E(DESLOC($B8;1;0;1;1)<=F$5;DESLOC($C8;1;0;1;1)>=F$5);E(DESLOC($B8;2;0;1;1)<=F$5;DESLOC($C8;2;0;1;1)>=F$5)) Abc J8 2. / Formula is =E($B7<=F$5;$C7>=F$5) Abc J9 1. / Formula is =E($B7<=F$5;$C7>=F$5) Abc J10 1. / Formula is =E($B7<=F$5;$C7>=F$5) Abc <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4