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