From Excel help:

Format a percentage Select Percent.
Valid values are from 0 (zero) to 100. Do not enter a percent sign.

Use a percentage when you want to visualize all values proportionally
because the distribution of values is proportional.

So, that's what Percent means!

The way that it's "presented" in the userform is very misleading. I'm sure
most users would think it means just as myself and the OP thought it meant.

So, set Type to NUMBER and use decimals as the boundaries.

--
Biff
Microsoft Excel MVP


"Tyro" wrote in message
t...
Sorry. Excel takes the range (key word!) you present, in this case 39 to
75 and divides it by 3 to determine the percent of the range <=33%, 34% to
66%,
=67% and applies those percentages to the range. The range from 39 to
75,
not 1 to 100.

Tyro
.
"T. Valko" wrote in message
...
What you describe is a percentile rank.

With icon sets there are 4 Types to choose from:

Number
Percent
Formula
Percentile

The behavior the OP describes is happening when I use Type Percent. This
doesn't seem correct (to me). If we set Type as Percentile then what you
describe should be the applied boundaries but this shouldn't apply to
Type Percent.

--
Biff
Microsoft Excel MVP


"Tyro" wrote in message
t...
The range you presented to Excel is from 39% to 75%. The upper 1/3 of
this range is from approximately from 63% to 75%, the middle 1/3 from
50% to 62% and the lower 1/3 is from 39% to 50%. So anything from 63%
and above is in green, from 50% to 62% in yellow and from 39% to 50% in
red. All figures are approximate. I'm too tired to compute this to the
nth degree of accuracy. Excel did it for us. :) Excel is not a mind
reader. It does not know that you think that your range is based on 1%
to 100%. Excel takes it as you presented it from 39% to 75% and divides
by 3.

Tyro

"DianneZ" wrote in message
...
Distribution Capacity
Atlantic 75%
Southwest 73%
Northwest 69%
North Central 54%
Mountain West 51%
Northeast 47%
Central 41%
Midwest 40%
Southeast 39%
the results of conditional formatting don't make sense to me,
on the example provided above :
if I apply "Icon sets" that look like the traffic lights
it applies green when value is = 67 %
applies yellow when value is <67% and = 33%
applies red when <33%

But in fact the last four values on the list show as red????
In my estimation only the last value should show as red...
Am I missing something here??
Thanks!
Dianne