mike leach
Member
Hi guys designed a loading/departure sheet working OK. Just need a formula best for a conditional formatting for the following. Basically I need for early = green, so before the departure time. Then this is the bit I am stuck with amber = 15 minutes Lee way after the departure time. Then red for after that time. Any help please. So the format of the table is departure time, live departure time and time difference. So I want and need the all three cells to change colour depending on the the time, like stated before. In the time deference column I have traffic lights which work really. And on the other two columns I want the tick for pass eg early and on time amber ⚠ for that 15 mins and red circle cross for late. Thanks Mike.