Forum Discussion
How to change the filled color if gantt chart displays completed
Please find the file from attached link for your reference.
Thanks for your help.
Thanks. Your rule applies to I5:Z5 and its formula is
=AND(ISNUMBER(SEARCH("completed",C5)),AND(ISBLANK(D5)=FALSE, ISBLANK(E5)=FALSE, ISBLANK(F5)=FALSE, ISBLANK(G4)=FALSE, ISBLANK(H5)=FALSE, ISBLANK(I5)=FALSE, ISBLANK(J5)=FALSE, ISBLANK(K5)=FALSE, ISBLANK(L5)=FALSE, ISBLANK(M5)=FALSE, ISBLANK(N5)=FALSE, ISBLANK(O5)=FALSE, ISBLANK(P5)=FALSE, ISBLANK(Q5)=FALSE, ISBLANK(R5)=FALSE, ISBLANK(S5)=FALSE, ISBLANK(T5)=FALSE, ISBLANK(U5)=FALSE))
In the first place, for this to work, ALL column references should be absolute: $C5, $D5, $E5 etc.
In the second place, it requires that ALL cells in C5:U5 are filled (none of them is blank). Is that really what you want?
- cchildaaJun 04, 2024Copper Contributorthanks for your reply. It doesn’t work. I dont know why. 😭😭😭
- HansVogelaarJun 04, 2024MVP
Do you really want to require that ALL cells in C5:U5 are filled (none of them is blank)?
- cchildaaJun 05, 2024Copper Contributor
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