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/11000067% if you wished.
--
David Biddulph

"Melody" wrote in message
...
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.