I want to create an "average color" formula.
 

I am trying to create an average color. For instance I have a
-group who is red on a project
-group that is yellow on a project
-group that is green on a project
so as a company we are yellow. I want the average color to populate as each
group (team) populates their color.

I want to create an "average color" formula.
 

Well, first you will need to decide how your colors 'average'.

One way is to assign an integer value to each color, maybe something
along the lines of Green = 3, Yellow = 2 and Red = 1. Then, per your
example, the average of 3+2+1 is 2 and you could use Conditional
Formatting to set the cell background / interior color to Yellow.

It gets, however, a bit more complicated if you have two that are
yellow and one that's red - the average of 2+2+1 is 1.667, so you'll
have to decide what color that is supposed to be.

Once you decide which value ranges map to what colors, Conditional
Formatting should get you the rest of the way...


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=112423

I want to create an "average color" formula.
 

Great answer! Now how about a step by step;)

"jamescox" wrote:


Well, first you will need to decide how your colors 'average'.

One way is to assign an integer value to each color, maybe something
along the lines of Green = 3, Yellow = 2 and Red = 1. Then, per your
example, the average of 3+2+1 is 2 and you could use Conditional
Formatting to set the cell background / interior color to Yellow.

It gets, however, a bit more complicated if you have two that are
yellow and one that's red - the average of 2+2+1 is 1.667, so you'll
have to decide what color that is supposed to be.

Once you decide which value ranges map to what colors, Conditional
Formatting should get you the rest of the way...


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=112423