Icond Set (conditional Formatting) of Excel 2007
 

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!

^_^

Icond Set (conditional Formatting) of Excel 2007
 

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!

^_^

Icond Set (conditional Formatting) of Excel 2007
 

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!

^_^

Icond Set (conditional Formatting) of Excel 2007
 

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!

^_^

Icond Set (conditional Formatting) of Excel 2007
 

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!

^_^