Weekly Planner- conditional formatiing

adusiiaa

New Member
Joined
Mar 21, 2019
Messages
1
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 :)!
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,108,510
Messages
5,523,318
Members
409,511
Latest member
hitesh222002

This Week's Hot Topics

Top