Icond Set (conditional Formatting) of Excel 2007

[badeth]

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!

^_^

 

[Jon Peltier]

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

- Jon

 

[badeth]

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]

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

 

[badeth]

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

^_^