3 Flag Icon Set not computing correctly

[Melody]

In an assignment for college, we used the 3 flag icon set to conditionally
format a column of revenues with $110,000 being the highest value. Any ideas
why the flag levels would not be computing correctly? We used the default
rule to green flag values => 67 percent, etc. The green flags included the
revenues $110,000-$85,000; yellow flags $78,000-55,000; and red flags
$50,000-$25000. Thanks for your insights.

 

[David Biddulph]

Sorry, this is microsoft.public.excel.worksheet.functions.
mindreading.crystal.ball is next door.
Why not tell us what conditions you are using in CF, what value you had in
the relevant cells, what result you got, and what result you expected?
Also, what version of Excel are you using, and what do you mean by the "3
flag icon", as that is not a term with which I am familiar in Excel 2003?
Don't forget that if you are referring to percentages, Excel will need to
know percentages of what.
If you are looking for >67% of 110000, your test would need to say

110000*67% or >73700; you coudn't get away with saying just >67%, but of

course you could test for =A2/110000>67% if you wished.

 

[Melody]

Excel 2007: Home tab/Styles/Conditional Formatting/Icon Sets/3 Flags
Then to edit the rule: Home tab/Styles/Conditional Formatting/Manage
Rules/Edit Rule/Dialog box

I have a column of revenues (,000 omitted for brevity's sake): 25, 30, 32,
35, 37, 39, 45, 45, 45, 45, 48, 50, 55, 56, 65, 65, 67, 75, 76, 76, 78, 85,
92, 95, 95, 100, and 110. After selecting the cells in the column and
following the above routine, the following result was returned:

Revenues $85,000 and greater returned a green flag
Revenues $55,000 through $78,000 returned a yellow flag
Revenues $25,000 through $50,000 returned a red flag

The rule was set such: Green flag => 67 percent
Yellow flag => 33 percent and < 67 percent
Red flag < 33 percent

Therefore, I expected green flags returned for revenues => $73,700 and so
forth. You are exactly correct when you say I need to designate 67% of what,
but unfortunately the dialog box does not allow for that and that is the
million dollar question I have--what value does Excel use to compute this
rule?? Not knowing what to expect, I expected Excel to look at the list of
values, select the highest value and make the computations from there.
However, it doesn't seem to work like that.