Help to create the proper schedule planner

[notrandom]

Hello everyone,
Thanks for visiting my post. I'm hoping you could help me make the ultimate work scheduler.

Please note the empty boxes... I've set "conditional formatting" to color fill each box once data is inputted. Please refer to photo
I was really hoping there was a way I could use conditional formatting to auto-color fill these empty boxes IF certain parameters match? Example: Would it be possible to direct an equation to C5 & C6, then through conditional formatting, direct these set of boxes to fill depending on matching data on D4 through AA4... Sigh... Does this make sense? Can anyone help? Essentially, I'd like these boxes to auto-color-fill depending on the hours set for P1, P2, etc...

Thank for your visit and your time. Any help would be greatly appreciated.

Have an awesome day!

 

[notrandom]

Any help or recommendations? Maybe a recommend a different direction?
Please help.

 

[Taul]

Hi,
One way is to use conditional formatting.
select cell D5 and apply conditional format, use the formula

[TABLE="width: 46"]
<tbody>[TR]
[TD="class: xl63, width: 46"]=AND(D$4>=$C$5,D$4<=$C$6)[/TD]
[/TR]
</tbody>[/TABLE]

ensure the "applies to" range says =$D$5:$AA$5

Hope this gives you a start point.
Also, it might be easier if the Time IN and OUT were in different columns (side by side) rather than stacked, so you only use one row for each "P" number.

Paul.

 

[notrandom]

Wow... Just... WOW. Thank you so much!!!
This worked. I'll definitely give your recommendation a shot and upload both results. (can excel forms be uploaded here?)
Well, anywho. Thanks! You are awesome!

 

[Taul]

You're welcome.

If you want to post a sample of the excel file, you can use the HTML Maker shown the the thread below:-
https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html