Conditional Formatting won't look at the format applied to the other cells,
but you can use Conditional Formatting (particularly the "Formula Is"
option) to define (using, if necessary, the content of columns A to AB) the
conditions which you wish to use to govern the format of column AC.
--
David Biddulph

"Doug" wrote in message
...
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?
--