Could really use a hand with conditional formatting based on an hourly gantt chart.

[figuare9]

Probably really gotta take a look at the pictures to see what I'm referencing here..

I have this partial hourly gantt chart I've heavily altered. It's separated every (2) hours.

I'm looking at entering data only on the left side. Essentially, only the task, date, and time. I'm looking for help on how to lay out the conditional formatting to make it so the data I enter, will format the gantt chart to the right. I'm not really sure on the best way to get it to work properly.

If I enter the date in my project start, it will automatically adjust the days to the right. The time will stay the same.

Please note; If an event starts or ends at an even time, (8A - 10A for example), I'd like it to fill from 7-11. (1 hour before, and one hour after) So on the left, it would read as 8A to 10A but would fill 7-11 in the gantt.

Here's what I have.

And here's what I'd like it to do, based on the data entered to the left.

Any help on this would be extremely appreciated. I'm definitely scratchin my head a bit here.

Thanks Guys!

 

[figuare9]

Here's a link to the sheet for reference as well.

Blank Gantt

 

[figuare9]

bump

 

[Georgegentry1]

Did you manage to get this sorted? I am trying to do the same thing but not getting anywhere at all with this. Any progress you have made would be greatly appreciated as I have a task where I need this function to work!