See http://www.xldynamic.com/source/xld.CFConditions.html to see how to
count CF colours.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Nicole" wrote in message
...
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.