| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display formula Excel uses for internal functions (STDEV...) | Excel Worksheet Functions | |||
| STDEV in a Formula for Calculated Field in Pivot Table | Excel Worksheet Functions | |||
| How to write STDev formula in a macro | Excel Programming | |||
| Conditional STDEV formula | Excel Programming | |||
| STDEV | Excel Discussion (Misc queries) | |||
Hybrid Mode
