Weekly Planner- conditional formatiing

[adusiiaa]

Hello,

I've created a weekly planner for revision, it has a start date, duration and % completed. The dates are in columns eg 29/03 am and 29/03 pm...

It's all great when i enter the duration as 1 day and it highlights both AM and PM for that day. Can anyone tell me what is the conditional formatting formula that i can input so that if i enter 0.5 as duration is would only highlight 29/03 am, or if i enter 1.5 it will highlight 29/03 am 29/03 pm and 01/04 am etc based on the start date.

Help Pleease !

 

[Special-K99]

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html