amandal2010
New Member
- Joined
- Feb 19, 2016
- Messages
- 1
=AND(F$2>=$C3,G$2<=$D3)
This is the formula I have in my conditional formatting for a gantt 24/*7 schedule.
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
I have column A employee name, column c start time, column d stop time
the above formula has worked for Sunday the first day in the schedule but is not highlighting the other days..can you help with a formula that will do a rolling 24/7 schedule, also having issues with the 3rd shift highlighting using this formula
This is the formula I have in my conditional formatting for a gantt 24/*7 schedule.
Angela Sanchez | 5:00 | 14:00 | |
Maria Grosso | 7:00 | 16:00 |
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
I have column A employee name, column c start time, column d stop time
the above formula has worked for Sunday the first day in the schedule but is not highlighting the other days..can you help with a formula that will do a rolling 24/7 schedule, also having issues with the 3rd shift highlighting using this formula