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.
[TABLE="width: 626"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Angela Sanchez[/TD]
[TD][/TD]
[TD="align: right"]5:00[/TD]
[TD="align: right"]14:00[/TD]
[/TR]
[TR]
[TD]Maria Grosso[/TD]
[TD][/TD]
[TD="align: right"]7:00[/TD]
[TD="align: right"]16:00[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 626"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Angela Sanchez[/TD]
[TD][/TD]
[TD="align: right"]5:00[/TD]
[TD="align: right"]14:00[/TD]
[/TR]
[TR]
[TD]Maria Grosso[/TD]
[TD][/TD]
[TD="align: right"]7:00[/TD]
[TD="align: right"]16:00[/TD]
[/TR]
</tbody>[/TABLE]
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