Evening all,
I'm looking for some help regarding conditional formatting.
As per the below image the rules should be as follows
1- Arrival time - (Green) = earlier or at the same time as the planned arrival time / (Red) = Any Time past Planned Arrival Time.
2- Finish Load Time - (Green) = earlier or up to 3 minutes after CPT / (Red) 4 minutes after CPT.
3- Actual Departure Time - (Green) = Earlier or equal to Allowed Departure time / (Red) = After Allowed Departure Time
Capture.PNG
Any Help would be greatly appreciated using conditional formatting.
Thanks all.
Bookmarks