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