Notifications
Clear all
Dashboards & Charts
2
Posts
2
Users
0
Reactions
195
Views
Topic starter
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!
Posted : 04/08/2020 1:36 pm
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
Posted : 04/08/2020 9:04 pm
