I have already a spreadsheet with traffic lights on it to show status in
projects. What I want to do is have a summary of the traffic lights for that
row. IE if all are green then the summary will appear green. If some are
amber and some green, but the majority are amber for instance I want the
summary to show amber.