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