Conditional Formatting Formula?

[Doug]

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

 

[David Biddulph]

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.

 

[Shane Devenshire]

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?

 

[Doug]

I have three stage color conditional formats for several of the columns, but
not all.
This means that it automatically ascribes a color between variables that I
have put in for those individual columns.

For example, if I have column A conditional formatted to give me a green for
numbers greater than 100 and red for numbers less than 50, it will return
those colors as well as intermediate or (in between) colors such as yellow on
the spectrum for values 51-99. It automatically decides intermediate color
based on the conditional formatting. In this example, 75 would be decided by
the program to be yellow which happens to be the 50% value of my set
parameters. It also shows all other in between colors.

Note that the reason I am trying to do this is... I already have the color
variables listed in the columns based on the (like) data in those columns.
But now I would like to weight each row by the individual colors in each
column. If I tried to weight them by the data instead of the ascribed color
is would defeat the purpose of having each column color formatted.

I hope this is making sense?

 

[David Biddulph]

As was said earlier, conditional formatting does not look at the *format* of
other cells, it can look only at the *value*. Define the rules based on the
value of the data in the relevant cells, and use them in CFs "Formula Is"
conditions.

 

[Doug]

Thank you
--
Have a great day!

As was said earlier, conditional formatting does not look at the *format* of
other cells, it can look only at the *value*. Define the rules based on the
value of the data in the relevant cells, and use them in CFs "Formula Is"
conditions.