Forum Discussion
Solved
Excel auto fill gantt chart by 15 min interval
Hi, I'm trying to make an auto-fill Gantt chart by 15 min intervals using conditional formatting. My current conditional formatting formula is =AND(H$1>=$C2,H$1<=$E2) * H1 is 0000 (start of th...
AH you need the rounding to include those partials. I see. You just need to offset that start time
Try:
=AND(I$1>$C2,H$1<=$E2)(but still applied to $H$2:$CZ$9 or whatever the end is)
