In Excel 2007, new feature of conditional formatting is the "icon set" in
which you can assign an icon on a particular value or range of values. i just
what to know how does the default condition of icon set work? by default,
excel is using the 67% and 33% but i want to know 67% of what or 33% of what?
how did they compute for that? i tried many ways but i cant get it. i hope
someone can enlighten my confused mind. thanks!

^_^

I believe the percentage scales from 0% at the minimum in the range being
formatted to 100% at the maximum.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"badeth" wrote in message
...
In Excel 2007, new feature of conditional formatting is the "icon set" in
which you can assign an icon on a particular value or range of values. i
just
what to know how does the default condition of icon set work? by default,
excel is using the 67% and 33% but i want to know 67% of what or 33% of
what?
how did they compute for that? i tried many ways but i cant get it. i hope
someone can enlighten my confused mind. thanks!

^_^

Hi,
yeah i know but what i want to know what is their default basis for them
to assign those icon set? they said that the default is 67% and 33% for the 3
icon set. but how do they get it or how did they compute it? i tried several
ways of computing it using the 67% and 33% but still it doesnt fit the
conditional formatting for icon set. is it the 67% or 33% of the total of the
range or what? im really confused. i need to know the answer coz for sure my
students will ask me about it. hope someone can help me...

thanks!

"Jon Peltier" wrote:

I believe the percentage scales from 0% at the minimum in the range being
formatted to 100% at the maximum.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"badeth" wrote in message
...
In Excel 2007, new feature of conditional formatting is the "icon set" in
which you can assign an icon on a particular value or range of values. i
just
what to know how does the default condition of icon set work? by default,
excel is using the 67% and 33% but i want to know 67% of what or 33% of
what?
how did they compute for that? i tried many ways but i cant get it. i hope
someone can enlighten my confused mind. thanks!

^_^

If MIN is the minimum in the range, MAX is the maximum in the range, and VAL
is the value in the cell, evaluate this fraction:

PCT = (VAL - MIN)/(MAX - MIN)

If PCT upper cutoff (67%) the icon will be the high one, if PCT < lower
cutoff (33%) the icon will be the lower one, otherwise it will be the middle
one.

Alternatively, the upper cut off value is

UCT = MIN + 67% * (MAX - MIN)

and the lower cut off is

LCT = MIN + 33% * (MAX - MIN)

Compare VAL to UCT and LCT to determine which icon it will be

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"badeth" wrote in message
...
Hi,
yeah i know but what i want to know what is their default basis for them
to assign those icon set? they said that the default is 67% and 33% for
the 3
icon set. but how do they get it or how did they compute it? i tried
several
ways of computing it using the 67% and 33% but still it doesnt fit the
conditional formatting for icon set. is it the 67% or 33% of the total of
the
range or what? im really confused. i need to know the answer coz for sure
my
students will ask me about it. hope someone can help me...

thanks!

"Jon Peltier" wrote:

I believe the percentage scales from 0% at the minimum in the range being
formatted to 100% at the maximum.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"badeth" wrote in message
...
In Excel 2007, new feature of conditional formatting is the "icon set"
in
which you can assign an icon on a particular value or range of values.
i
just
what to know how does the default condition of icon set work? by
default,
excel is using the 67% and 33% but i want to know 67% of what or 33% of
what?
how did they compute for that? i tried many ways but i cant get it. i
hope
someone can enlighten my confused mind. thanks!

^_^

Thank you very much! you solve my problem. again thank you!

^_^

"Jon Peltier" wrote:

If MIN is the minimum in the range, MAX is the maximum in the range, and VAL
is the value in the cell, evaluate this fraction:

PCT = (VAL - MIN)/(MAX - MIN)

If PCT upper cutoff (67%) the icon will be the high one, if PCT < lower
cutoff (33%) the icon will be the lower one, otherwise it will be the middle
one.

Alternatively, the upper cut off value is

UCT = MIN + 67% * (MAX - MIN)

and the lower cut off is

LCT = MIN + 33% * (MAX - MIN)

Compare VAL to UCT and LCT to determine which icon it will be

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"badeth" wrote in message
...
Hi,
yeah i know but what i want to know what is their default basis for them
to assign those icon set? they said that the default is 67% and 33% for
the 3
icon set. but how do they get it or how did they compute it? i tried
several
ways of computing it using the 67% and 33% but still it doesnt fit the
conditional formatting for icon set. is it the 67% or 33% of the total of
the
range or what? im really confused. i need to know the answer coz for sure
my
students will ask me about it. hope someone can help me...

thanks!

"Jon Peltier" wrote:

I believe the percentage scales from 0% at the minimum in the range being
formatted to 100% at the maximum.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"badeth" wrote in message
...
In Excel 2007, new feature of conditional formatting is the "icon set"
in
which you can assign an icon on a particular value or range of values.
i
just
what to know how does the default condition of icon set work? by
default,
excel is using the 67% and 33% but i want to know 67% of what or 33% of
what?
how did they compute for that? i tried many ways but i cant get it. i
hope
someone can enlighten my confused mind. thanks!

^_^