Hi,

What are the conditions that control the colors, what do you define as
intermediate? How many colors can you have on a row? These are all
questions you must answer first. And how do you weight them - for example, 5
greens and 1 red? = 5/6 green 1/6 red --- what color is that?

For example what is the average or yellow and brown, of green and red, of 3
green's and 1 red's? What is the average of 1 green, 1 red, 1 yellow, 1
gray, 1 purple and 1 blue cell?

If you have a blue shirt and black pants what color must the tie be?
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Doug" wrote:

I have used conditional formatting on data listed in columns A through AB. Is
there a formula that I can use to give me an intermediate or average color
for all the columns combined to show in a new column? (column AC)

For example, if in row 1, Columns A through AB have one red, one yellow, and
one green, then column AC would show the intermediate color yellow as and
average of the three?
--