Gantt Chart- colouring bars

[1988craig]

Hi Everyone,

I have used excels template 'Gantt project planner'.
I have multiple trades on the sheet & I am trying to colour the bars different colours for the retrospective trade.

Can I edit the existing conditional formatting to differentiate between the trades, and if so could you please advise how?

I am not using the features in the template for tracking- actual start & progress etc only the planned start date.

Please see the example, many thanks & very much appreciated for the assistance.

 

[1988craig]

Post updated- many thanks

Gantt project planner example.xlsx
	C	D	E	F	G	H	I	J				N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ
5
6		Period Highlight:	week 1									week 1
7		Start	02/11/2020		PLAN START	PLAN DURATION	start date	Start Time				02/11/2020							03/11/2020							04/11/2020							05/11/2020							06/11/2020							07/11/2020							08/11/2020
9		End	15/01/2021	trade								Monday							Tuesday							Wednesday							Thursday							Friday							Saturday							Sunday
11												1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49
12				Trade 1	3	2	02/11/2020	08:00:00
13				Trade 2	381	6	15/01/2021	08:00:00
14				Trade 3	2	4	02/11/2020	07:00:00
15				Trade 4	53	8	12/11/2020	09:00:00
16				Trade 1	4	2	02/11/2020	09:00:00
17				Trade 2	4	3	02/11/2020	09:00:00
18				Trade 3	40	4	09/11/2020	10:00:00
19				Trade 4	5	2	02/11/2020	10:00:00
20				Trade 1	5	2	02/11/2020	10:00:00
21				Trade 2	6	5	02/11/2020	11:00:00
22				Trade 3	6	1	02/11/2020	11:00:00
23				Trade 4	8	3	03/11/2020	06:00:00
Project Planner

Cell Formulas
Range	Formula
E7	E7	=MIN(I12:I43)
U7,BD7,AW7,AP7,AI7,AB7	U7	=N7+1
N9,BD9,AW9,AP9,AI9,AB9,U9	N9	=N7
E9	E9	=MAX(I13:I44)
I12:I23	I12	=VLOOKUP(G12,Sheet1!$A$2:$C$2430,3,FALSE)
J12:J23	J12	=VLOOKUP(G12,Sheet1!$A$2:$C$2430,2,FALSE)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
U7:AYJ10	Expression	=WEEKDAY(U$8,2)>5	text	NO
U11:AYJ11	Expression	=WEEKDAY(U$8,2)>5	text	NO
U12:AYJ43	Expression	=PercentComplete	text	NO
U12:AYJ43	Expression	=PercentCompleteBeyond	text	NO
U12:AYJ43	Expression	=Actual	text	NO
U12:AYJ43	Expression	=ActualBeyond	text	NO
U12:AYJ43	Expression	=Plan	text	NO
U12:AYJ43	Expression	=U$4=period_selected	text	NO
U11:AYJ11	Expression	=U$11=period_selected	text	NO
U12:AYJ43	Expression	=MOD(COLUMN(),2)	text	NO
U12:AYJ43	Expression	=MOD(COLUMN(),2)=0	text	NO
N7:T10	Expression	=WEEKDAY(N$8,2)>5	text	NO
N11:T11	Expression	=WEEKDAY(N$8,2)>5	text	NO
N12:T43	Expression	=PercentComplete	text	NO
N12:T43	Expression	=PercentCompleteBeyond	text	NO
N12:T43	Expression	=Actual	text	NO
N12:T43	Expression	=ActualBeyond	text	NO
N12:T43	Expression	=Plan	text	NO
N12:T43	Expression	=N$4=period_selected	text	NO
N11:T11	Expression	=N$11=period_selected	text	NO
N12:T43	Expression	=MOD(COLUMN(),2)	text	NO
N12:T43	Expression	=MOD(COLUMN(),2)=0	text	NO