67% of what????

Tyro

"T. Valko" wrote in message
...
Well, that's not the first thing I think of when I see:

= ... 67 ... Percent

I think: if the cell value is = 67% apply this format.

--
Biff
Microsoft Excel MVP


"Tyro" wrote in message
t...
In conditional formatting as in anywhere else in mathematics, percent
applies to the range of numbers to which it applies. For example if I
have a range of numbers from 6 to 14, the lower 33% are the numbers 6, 7,
8 and the middle 33% are the numbers 8, 10, 11 and the upper 33% are the
numbers 12, 13 and 14.

Tyro

"T. Valko" wrote in message
...
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