Log In
Register
Home
Modify a Gantt Chart
Katherine Williams
Member
Members
Forum Posts: 12
Member Since:
June 11, 2020
June 11, 2020
Offline1
August 4, 2020 - 3:36 am
Hi there! I'm trying to make a change on a Gantt Chart that involves conditional formatting. Right now, when I add start and end dates to my tasks, let's say on B11, a solid green bar is created. I would like to have that bar change to specific colors if the word "deliver", "galvanize" or "install" is found in cell B11, and so on through all the tasks. Is this possible?
I have attached a copy of my Excel file.
Thank you so much for your help!
Mynda Treacy
Admin
Forum Posts: 4619
Member Since:
July 16, 2010
July 16, 2010
Offline2
August 4, 2020 - 11:04 am
Hi Katherine,
Yes, you'll need to create 3 separate rules, one for each colour. The rules then need to include a criteria in the AND formula to check if cell B11 contains one of the words. e.g. for Deliver:
=AND(NOT(ISBLANK($I11)),$I11<=T$7,$J11>=T$7,IFERROR(SEARCH("Deliver",$B11),FALSE))
Mynda
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Barbara Murray
Guest(s) 12
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: 185
Newest Members:
Kwaje Alfred Mogga
thong nguyen
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Rob Rooth
Forum Stats:
Groups: 3
Forums: 24
Topics: 6544
Posts: 28650
Member Stats:
Guest Posters: 49
Members: 32831
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —