ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional Format Not Working (https://www.excelbanter.com/excel-discussion-misc-queries/264178-conditional-format-not-working.html)

sly411

Conditional Format Not Working
 
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.



All times are GMT +1. The time now is 03:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com