Luke: A VBA-based answer would be nice. However...

There is a cell (N2) containing the goal value of "80" (percent). If I knew
how to include all of the cells in the range in the "IF" statement, I could
say "If all of these cells are greater than or equal to cell N2, then color
this cell green - (or, failing that, make this cell say "YES" and then
conditionally format all of the "YES" cells as green). They prefer a green
stoplight to green fill, by the way.

There is a second cell for the "Yellow" cutoff, too.

DOUG
"Luke M" wrote:

Sadly, you can't write a formula based on colors. (Well, without using VBA)
However, is there some function/conditional format making the other cells
these colors? If so, you/we can create a formula based on that.
--
Best Regards,

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


"DOUG ECKERT" wrote:

I have a co-worker who wants to insert a formula to say "If all of the cells
in a range are green, then this cell is green. If some cells are yellow,
then this cell is yellow. If any cells are red, this cell is red".

??

DOUG