Fill cell(s) with colour based on Duration/Time and Words

Bump, anyone could help?

Please post a sample workbook as we cannot see nor work with images.

Click "Go Advanced" then paper clip icon to start upload.

Originally Posted by JohnTopley

Please post a sample workbook as we cannot see nor work with images.

Click "Go Advanced" then paper clip icon to start upload.

example.xlsx

Attached, as you can see, I highlighted the cell manually however I want it done automatically + reading my description.

Any thoughts on possible how?

uploaded here, sorry

It is too early in the morning to think about this but you could highlight cells using Conditional Formatting which could colour cells which are not blank.

this means. for example. entering "M+P" in D7 and dragging down to D10. Cells D7 to D10 would be highlighted.

The attached is an example with conditional formatting in D & F.

Originally Posted by JohnTopley

It is too early in the morning to think about this but you could highlight cells using Conditional Formatting which could colour cells which are not blank.

this means. for example. entering "M+P" in D7 and dragging down to D10. Cells D7 to D10 would be highlighted.

The attached is an example with conditional formatting in D & F.

I don't want to manually drag because the point is to try automatically have the cells filled based on efficiency rather than having to do more steps but thanks for your input and I already knew your method however it isn't what I desire unfortunately.

For it to be automated we need a table with times and personnel i.e.. to enable the timetable to be filled. It may be possible to fully automate the process - I will give it some thought!

Originally Posted by JohnTopley

For it to be automated we need a table with times and personnel i.e.. to enable the timetable to be filled. It may be possible to fully automate the process - I will give it some thought!

if you could, this would be helpful~! will be looking forward to an result/example

really appreciate all the help i can get with this.

Is it person dependent? For example, is M+P always 45 minutes no matter who it is?

BTW, the typical scheduling paradigm is each time slot, designated by beginning time, is equal to 15 minutes. When you fill 4 slots, with an interval of 15 minute start times, would equal one hour... not 45 minutes!

Anyway, attached performs as desired for "M+P", as an example. The others should simply be a matter of duplicating conditional formatting ranges and formula (alter formatting as desired), with the exception you will replace the "M+P" term in the formula with the desired term (e.g "B/Dry").