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”, C5), however, it seemed not working out. What could I do? 

​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”, C5), however, it seemed not working out. What could I do?   Read More

​