Hello,
It has been a bit since a statistics class and I cannot remember which
formula(s) I should be using. What I am trying to do is this: I have data
that I want to apply conditional formatting data bars to, but the bars are
not useful if they range from min to max. The data is really large but only
varies by a small percentage, so I would like the bars to represent this.
The data ranges from 9.360E+07 to 9.362E+07 and this is a pretty small
difference so min to max is not useful. Not all of the data has such a small
range, though, for instance 582 to 2677 or 6.4E7 to 1.4E8. Right now the
best I have is 10 minus the number of standard deviations from the max. Any
help is appreciated.

Thanks,
Brandon