Green Up x seconds before event start
Can somebody advise how the formula should look for greening up x seconds before an event start time. I can get the timer to trigger using something like =IF(HOUR($F$4)<2,"Do something","") but it's the greening up bit that I can't figure out. I have the WITH_GREENING:TRUE command in there but it only greens up when the back and lay are both matched. I want to green up regardless at a predefined time period before the event goes in play.