Melanie Olivant
Member
Members
Forum Posts: 12
Member Since:
May 29, 2019
May 29, 2019
Offline
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: 4703
Member Since:
July 16, 2010
July 16, 2010
Offline
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: Riny van Eekelen, Xu Zhi Jie, Julia Sun
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 289
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
chutima thongnan
David Ball
Ali Asghar
Carmen Arico
Raymond Costelloe
Jeanette Noriega
Michael Padilla
Edward Atalla
John Woodley
Alexandra Tataru
Forum Stats:
Groups: 3
Forums: 24
Topics: 6876
Posts: 30138
Member Stats:
Guest Posters: 49
Members: 33687
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —