I'm trying to green all on the off. I've got an IF formula in cell AF3 that displays "1" when the event's start time is reached. The Global Command cell (L6) contains another IF function that inserts the text "GREEN_ALL" if AF3 = "1". The problem is that the formula places rather than enters the text into L6: Excel doesn't fire the GREEN_ALL command through to BetAngel.
I've been trying all sorts of macro/vb type stuff but have limited capability and would be very grateful if anyone has a solution to my problem.
Many thanks
John.
