Forum Discussion
Issue with Icon Set in Conditional Formatting
The colour of the icons are just not reflecting the instruction which i had input. Please refer to attachment. Could it be the setting is wrong or my software issue ? Hope you can hep guide f...
Technically there is no error here - you use value, percent of value, or formula which calculates based on value. I could agree that the name of the second column with bars ("Type") is not correct and could confuse and forward to association with values types (number, date, percent, currency, etc).
Technically, Excel doesn't know how to correctly handle percents and produces incorrect outcomes. This is basic functionality we install into our fourth graders. Unfortunately, programmers never accept that there is a bug. I used to manage the marketing and product development processes development for Intuit's consumer tax division. We'd call this a bug. Not even sure that it's reasonable to disagree. If we were talking about it in person I'd mock you to your face. Get it fixed.