I'm using Excel 2007 and their conditional formatting tab. Within it, the user can format cells based upon the value being 1, 2, or 3 standard deviations above/below the mean. Theoretically, Excel should be calculating the mean and standard deviation, but it appears there could be an error in the internal calculations.

In my case, I'm formatting cells if they are 2 or 3 standard deviations from the mean (different color schemes for each).

---
frmsrcurl: http://msgroups.net/microsoft.public...dard-Deviation