Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting ROW not working | Excel Discussion (Misc queries) | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
Conditional Format Not Working | Excel Worksheet Functions | |||
working with conditional and lookups | Excel Discussion (Misc queries) | |||
Conditional Format Not Working | Excel Discussion (Misc queries) |