StevieG35

New Member
Joined
Mar 22, 2017
Messages
1
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:
StartEnd
Main TaskYY---YYY---YYY
SubTask 1​
3/23/173/31/17xx
SubTask 2​
4/10/174/17/17xxx
SubTask 3​
4/20/174/30/17xxx

<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
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Worf

Well-known Member
Joined
Oct 30, 2011
Messages
4,010
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
CellNr.: / ConditionFormat
J81. / 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
J82. / Formula is =E($B7<=F$5;$C7>=F$5)Abc
J91. / Formula is =E($B7<=F$5;$C7>=F$5)Abc
J101. / Formula is =E($B7<=F$5;$C7>=F$5)Abc

<tbody>
</tbody>

<tbody>
</tbody>


Excel tables to the web >> Excel Jeanie HTML 4
 

Watch MrExcel Video

Forum statistics

Threads
1,109,275
Messages
5,527,721
Members
409,784
Latest member
AdamPriest

This Week's Hot Topics

Top