Fill Cell(s) with colour based on duration/time and keywords

Hi everyone, I need some help on a urgent request.

I'm trying to make a timetable/schedule system which basically fills certain cells selected based on duration/time of a specific word/phrase for example, in this picture

eZAXAFw.jpg

As you can see, Jessica is booked in at 11am, M+P duration is 45mins as you can see, the highlight stops at the 11:45am. B/Dry starts at 10:30am and ends at 11am. Is this function possible in some way?

The way I currently do it is manually highlight the cells however I was wondering if this operation could be done automatic?

So if I select for example, D7 and write M+P there, it would highlight 4 cells from D7, which would result D7,D8,D9,D10 highlighted.

If anyone could help me, I would really appreciate this as this up for a very important assignment.

Thanks everyone~!

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

I have attached an example.

QVuONgr.png

Here's a example picture, as you can see, I want keywords such as "M+P" to highlight 4 cells below and "B/Dry" to highlight 3 cells for example, if "+/" can't be used, it doesn't matter. I just want to try get keywords multi-cell filled with colour (a way of showing duration)

Right now, I have to manually highlight the cells and fill with colour, I was wondering if theres an automated way based on finding the criteria of certain words to fill multiple cells below from the first selected cell, if M+P is on D5, D5/D6/D7/D8 will be filled.

I was wondering if this could be easily filled by just words, so I don't have to add the formula everytime, something similiar to like a VLOOKUP? where you just look up word and it will do the result for you automatically if that makes sense?

Thanks for your help!