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 fast.
Thank you.
Rgds,
Disturbed
This has not yet fixed yet -- creates confusion for the general user -- Kindly rectify this towards user friendly approach
Hi Jocephin,
Yes, it'wrong setting. Please use Number in rule and values as 1.0, 0.8 to define the ranges. If you use Type percent it means percent of the cell value, not what you cells formatted as %. For example, if you have 76% in the cell and your rule says to make green values more than 100 percents that menas more than 100% of 0.76.
Please see attached with corrected rules.
SergeiBaklan This is still an issue in 2019 and really needs to be fixed. We run into it all the time. It is an error in Excel's programming. Shocked that Microsoft has let this error go on this long!
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).
