|
Posted to microsoft.public.excel.programming
|
|
|
stdev CF Formula
--
Thank you!
"p45cal" wrote:
(Excel 2007 below)
In 2003:
Raw data in A1:A30:
355
If you cant see the picture, it's at
http://tinyurl.com/y8vumd3
This picture shows the cf formulae in cell A1, but I think you could
select the whole range and enter the same formulae and it should work.
In xl2007 there is the built in facility to do exactly what you want -
no formulae required. Select the entire raw data range, on the -Home
-tab click on -Conditional formatting-, -Color Scales, More Rules-,
Select the rule type: -Format only values that are above or below
average-, in the -Format Values- dropdown choose -1 std dev above-,
choose your formatting and OK.
Repeat the exercise choosing -1 std dev below-. You end up with the
range having two CF rules.
+-------------------------------------------------------------------+
|Filename: 2009-11-13_151904.jpg |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=355|
+-------------------------------------------------------------------+
--
p45cal
*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=153650
Microsoft Office Help
.
|