Forum Discussion
How to change the filled color if gantt chart displays completed
Hi everyone. I want to change filled color automatically based on original conditional formatting if gantt chart displayed "completed". I tried new conditional formatting =isnumber(search("completed"...
HansVogelaar I just wanna change the cell color if C5 displayed “completed”. Like pic 1 changed to pic 2
pic 1
pic 2
However, I don’t know why the above formula not working
Change the formula to
=ISNUMBER(SEARCH("completed",$C5))
and apply it to =$I$5:$Z$34
You may want to inspect the rest of the conditional formatting rules.
