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