I want to create an "average color" formula.

[seancalleja]

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.

 

[jamescox]

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...

 

[seancalleja]

Great answer! Now how about a step by step