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: 4517
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:
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Gilbert Lemek
Ashleigh Farquharson
Jayz Luu
Fred Smith
Charles DeGraffenreaid
Cathi Giard
Sarah Young
Henry Delgado
Alita Nieuwoudt
KL KOH
Forum Stats:
Groups: 3
Forums: 24
Topics: 6360
Posts: 27812
Member Stats:
Guest Posters: 49
Members: 32340
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —