S
sly411
I have been using a simple red, yellow, green ICON Set to evaluate a field
but the wrong icon comes up when the value matches the formula exactly.
Rule:
Green when value is >= cell 1 + cell 2
Yellow when < formula and >= cell 1
Red when < formula
When the field value exactly matches cell 1 + cell 2, the icon comes up
yellow instead of green. Note, if the rule for green is when value >= cell 3
i.e. no formula, then the green icon shows up fine. Also note that it doesn't
matter if the Type is "formula" or "number".
Let me know if I am doing something wrong or if you can replicate this
issue. And if you can replicate it how do I report it to Microsoft or find
out if they have a fix.
but the wrong icon comes up when the value matches the formula exactly.
Rule:
Green when value is >= cell 1 + cell 2
Yellow when < formula and >= cell 1
Red when < formula
When the field value exactly matches cell 1 + cell 2, the icon comes up
yellow instead of green. Note, if the rule for green is when value >= cell 3
i.e. no formula, then the green icon shows up fine. Also note that it doesn't
matter if the Type is "formula" or "number".
Let me know if I am doing something wrong or if you can replicate this
issue. And if you can replicate it how do I report it to Microsoft or find
out if they have a fix.