Excel spreadsheet for work formula

Hi everyone, I've just started a new job that requires zone closures when an agent is no longer available. I'm looking for an equation that can give me a traffic light system or some signal as to w...