Forum Discussion
Gantt chart date formula
I have a row listing the dates of weeks commencing for each month. I want the Gantt chart to fill each block if the date occurs in that week. At the moment, it won't fill if the start date isn't ...
Use this one in stead. Then it works as you want it to, I believe.
=AND(ISOWEEKNUM(J$6)>=ISOWEEKNUM($F7), ISOWEEKNUM(J$6)<=ISOWEEKNUM($G7))Should a project carry over a year-end you probably need to work in the year also.
Thanks! What if I then want to change the colour depending on another cell value?
=ISNUMBER(SEARCH("Low risk",$C8))
Do I just add this into the formula you gave?
Sorry, forgot to address the risk element. This one should work for "Low risk". You need separate rules for each risk category. Just replace the "Low risk" part and select you colour.
AND(ISOWEEKNUM(J$6)>=ISOWEEKNUM($F8), ISOWEEKNUM(J$6)<=ISOWEEKNUM($G8),$C8="Low risk")Please see attached. Works for me. Didn't do all and the colours are probably not what you want. But hope you can get it work.