You omitted to tell us what conditions you have set in CF, so it's difficult
for us to tell you what you've done wrong.
--
David Biddulph


Steve wrote:
Trying to ascertain if there is a bug in Excel 2007, or I'm
misinterpreting how "Conditional Formatting" works.

In short, I have a series of investment returns where I want to check
for outliers beyond two and three standard deviations. I used the
"Conditional Formatting" style box, and highlighted the cells
appropriately.

For one population, the mean is 2.55 with a standard deviation of .73
Thus, when I'm checking for +/- two standard deviations, values less
than 1.09 (2.55 - 2*.73) and greater than 4.01 (2.55 + 2*.73) should
show up with their respective formatting.

The odd part is that values that are between the lower bound (1.09)
and the mean (2.55) incorrectly are highlighted. But this does not
happen on the higher side of the mean. Secondly, even if I change
the criteria to one, two, or three standard deviations below average,
the same cells get highlighted.

Am I misunderstanding how the Excel conditional formatting works, or
is there a bug?

Kind regards,
Steve