conditional formatting based on another cells formula result
 

Is it possible to have Excel do conditional formatting of a cell based on the
reults of a different cell?

For example, I have a column of data that give the averages of several
numbers in a row. I would like to have those averages change color if the
stadard deviation of those numbers is above a certian value. Is it possible
to do this within the conditional formatting menu option or is there some way
to link it to another column where I have the standard deviation calculated?

If you use Formula Is vs. Cell Value Is and create your equation there
and set the conditions.

I have used this function comparing a value in a cell to the averave of
three other cells and changing the text to red if the cell value was
greater than the average.

Hope this helps.


--
TimR
------------------------------------------------------------------------
TimR's Profile: http://www.excelforum.com/member.php...o&userid=27843
View this thread: http://www.excelforum.com/showthread...hreadid=473502

Highlight the cells that have the averages, then go to conditional
formatting. Using a formula, reference the standard deviation cell with
criteria (<, , =, etc.). Your averages will then change color based on the
standard deviation.

"kstarkey" wrote:

Is it possible to have Excel do conditional formatting of a cell based on the
reults of a different cell?

For example, I have a column of data that give the averages of several
numbers in a row. I would like to have those averages change color if the
stadard deviation of those numbers is above a certian value. Is it possible
to do this within the conditional formatting menu option or is there some way
to link it to another column where I have the standard deviation calculated?

One way;
In cell you want to change format
Format Conditional Format Change cell value is to formula is
=a1x and set the format
A1 is the average and x is the value
HTH


"kstarkey" wrote:

Is it possible to have Excel do conditional formatting of a cell based on the
reults of a different cell?

For example, I have a column of data that give the averages of several
numbers in a row. I would like to have those averages change color if the
stadard deviation of those numbers is above a certian value. Is it possible
to do this within the conditional formatting menu option or is there some way
to link it to another column where I have the standard deviation calculated?