Sounds to me as though you have most of it already figured out. I gather you already know where to find the traffic lights, and you know which cell is to provide the data. What are you missing?

Maybe you should explain what you've done so far, and where you get stopped. Oh, and what version of Excel are you using?