Forum Discussion
Conditional Formatting gantt which has a weekly column header
Hi, I have a gantt chart which I've set to conditional format cells which have a start and end date. The time range for the gantt is set up weekly. However, if a milestone or activity is less than...
Thanks Martin_Weiss. That's great. Regards the rounddown conditional format rule, how do I update this so it populates from the start date. As you can see if the attached it starts one cell to the right of the gantt bar, cell AE4, AE7. Also for cell AA12 and AC13 it does not populate at all. Current rule below.
=AND($I4<=O$3,ROUNDDOWN(($J4-$I4+1)*$G4,0)+$I4-1>=O$3)
=AND($I4<=O$3,ROUNDDOWN(($J4-$I4+1)*$G4,0)+$I4-1>=O$3)
Martin_Weiss. File attached.