stdev CF Formula

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

How can I enter a standard Deviation formula in CF? I have tried several ways
and can't figure it out?
--
 
Sorry for the lack of detail. I am wanting to use the two color scale in CF
and under the minimum and maximum value enter a formula for the standard
deviation of the data in that column. On the minimum side, I am wanting it to
highlight data red when it exceeds -1 stdev, and on the maximum side
highlight data green when it exceeds 1 stdev. This way I can see highlighted
data for only values more than one stdev away from the mean. I may use the
three color scale so to define what a center mean will be (usually 0). I just
need to know what I should type into both the min and max to retrieve these
results.
--
Thank you!


p45cal said:
Doug;557054 said:
How can I enter a standard Deviation formula in CF? I have tried several
ways
and can't figure it out?
--
Click to expand...
A bit short on detail here.
How do you want to restrict entries?
Where does the info come from for the arguments that make up the
formula?


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=153650

Microsoft Office Help

.
Click to expand...
 
I'm using 2007
--



p45cal said:
I beg your pardon - I read DV (Data validation) instead of CF!
I'm working on it, but xl2007 is significantly different from earlier
versions of Excel in this respect. Which version are you using?

Doug;557601 said:
Sorry for the lack of detail. I am wanting to use the two color scale in
CF
and under the minimum and maximum value enter a formula for the
standard
deviation of the data in that column. On the minimum side, I am wanting
it to
highlight data red when it exceeds -1 stdev, and on the maximum side
highlight data green when it exceeds 1 stdev. This way I can see
highlighted
data for only values more than one stdev away from the mean. I may use
the
three color scale so to define what a center mean will be (usually 0).
I just
need to know what I should type into both the min and max to retrieve
these
results.
Click to expand...


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=153650

Microsoft Office Help

.
Click to expand...
 
Back
Top