Icond Set (conditional Formatting) of Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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!
 
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
 
Back
Top