For this example, lets presume your actually looking for the words "red"
"green" and "yellow"

Condition 1:
=COUNTIF(A2:G2,"red")0
format red

Condition 2:
=COUNTIF(A2:G2,"yellow")0

condition 3:
=COUNTIF(A2:G2,"green")=7
format green (where 7 is equal to number of cells you are checking)

Obviously, you can change the COUNTIF function to depend on your actual
criteria.
For the wording of the cell, simply combine these into
=IF(COUNTIF(A2:G2,"red")0,"No",IF(COUNTIF(A2:G2," yellow")0,"Marginal",IF(COUNTIF(A2:G2,"green")=7, "Yes","Did not meet any crtieria")))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"DOUG" wrote:

A co-worker wants to color-code a summation cell, so that if ALL of the cells
in that row are GREEN (i.e., in compliance or above the goal), then the
right-hand cell will be GREEN or "YES". If any cells are rated YELLOW, or
marginal, then the final cell will also be YELLOW or marginal. If any cells
are RED, then the final cell will coded RED or say "NO". (We can use
Conditional Formatting to color the result cells after-the-fact if need be.
She would prefer to use stoplight symbols, GREEN-YELLOW-RED in the right-hand
column and to sort by them if possible). Is this possible - (with a
reasonable amount of effort)? So far, I have tested IF statements, AND
statements and LOOKUP statements without success.
DOUG