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)
That formula seems correct assuming the RANGE the conditional formatting is applied to is $H$2:$CZ$2 (the formula must be correct for the top left corner of the Applied To Range)
If you want row 9 then replace the 2 with 9 or better yet if you want all the rows from 2 down to 9 then then just use that SAME formula and make the Applied To Range:
$H$2:$CZ$9 (notice again the top left corner is still H2 and so will work)
- for example the start time is 0520
i will only highlight the cell for 0530 instead of from 0515
