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"...
thanks for your reply. It doesn’t work. I dont know why. 😭😭😭
Do you really want to require that ALL cells in C5:U5 are filled (none of them is blank)?
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.
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