Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
Conditional formatting blank cells | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
conditional formating - Highlighting text cells based on sales res | Excel Discussion (Misc queries) |