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: 4769
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: Alan Sidman
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 919
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 339
David_Ng: 306
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Michael Denton
Nick Pascal
David Webb
Johannes Bruentrup
John Jay
Larry Silverman
David Rousseau
Melinda Heidemann
Jose Fuentes
Abigail Hernandez
Forum Stats:
Groups: 3
Forums: 25
Topics: 7072
Posts: 30993
Member Stats:
Guest Posters: 49
Members: 34469
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —