Using an expression like this:

=(number-min)*100/(max-min)

you will end up with a range that varies from 0 to 100. You can change
the scaling factor if you want a smaller (or larger) range.

Hope this helps.

Pete

On Nov 27, 5:22*pm, Brandon wrote:
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