![]() |
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 01:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com