Colour And Shift Number Of Cell Groups Specified By Two Cells

Okay,

I have a schedule-type worksheet that is split up into five days a week, eight hours a day, for 2 machines. A new job is entered into the first available hour slot for each machine, and colour-coded to show how many hours this job will take. The next job will be entered directly after the colour-coded cells from the prevoious job. This is all shown clearly in the attachment. I'm trying to streamline this whole process where this will happen:

When a new job is entered, the HRS cell will receive the hours the job will take, and the SHIFTS cell will receive either 1, 2, or at the most 3. So basically, if it's a 32 hour job on 1 shift, then that column of cells plus 31 more to the right will get highlighted a colour, in this case light blue. If it's a 38 hour job on 2 shifts, it would take half the time of 1 shift (1 shift = 8 hours), so that column plus 18 more to the right of it would turn purple.

I'm looking for a code that will do this automatically, which I don't think is too much of an issue - what I'm wondering as well though, is whether this code would be able to reflect any changes to previously entered HRS/SHIFTS - so if I go back to my first example and change it to say, a 2 shift, or a 16 hour job, only 16 cells would be light blue now, and the rest of the entered jobs to the right of this job would be shifted to the left 16 cells.

If anyone could have a look at this I'd really appreciate it - even if you tell me I'm way out to lunch.

Does anyone think they could help with this?

I'm still wondering if this is doable...