
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: 4614
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: Martin Delloca, Tracy English, Joaquim Amorim, Rob Starren
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 183
Newest Members:
Rob Rooth
Tom Lewis
Jennifer Rodriguez-Avila
Khaled Ibrahim
Kiran Supekar
Lisa Myers
Ronald White
Ginette Guevremont
Taryn Ambrosi
Mark Davenport
Forum Stats:
Groups: 3
Forums: 24
Topics: 6531
Posts: 28604
Member Stats:
Guest Posters: 49
Members: 32821
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
