
Melanie Olivant
Member
Members

Forum Posts: 12
Member Since:
May 29, 2019
May 29, 2019

Hello,
Hoping you can help me.
I am using the Gantt Template provided by Excel and looking to customise it.
I'm having some difficulty in colour coordinating the shaded date lines to the contractor - sheet attached.
Any help appreciated.

Mynda Treacy
Admin

Forum Posts: 4443
Member Since:
July 16, 2010
July 16, 2010

Hi Melanie,
Thanks for clarifying. You need to set up separate rules for each Contractor that includes an AND clause in the rule formula to test for the contractor in column B e.g.:
For JGS contractor, instead of the rule:
=Actual
You'll need:
=AND(Actual,$B5="JGS")
Then set the format to green fill.
Repeat for all rules. Obviously this will result in a lot of conditional formatting rules.
Mynda

Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: baber Tufail
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
drsven
Annie Witbrod
wahab tunde
Cong Le Duc
Faisal Bashir
Ivica Cvetkovski
Blaine Cox
Shankar Srinivasan
riyepa fdgf
Hannah Cave
Forum Stats:
Groups: 3
Forums: 24
Topics: 6205
Posts: 27211
Member Stats:
Guest Posters: 49
Members: 31880
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
