Sep 01 2017 03:56 PM
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
Sep 02 2017 10:06 AM
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.
Sep 25 2019 10:59 AM
@Sergei Baklan 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!
Sep 25 2019 01:24 PM
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).
Sep 25 2019 02:00 PM - edited Sep 25 2019 02:23 PM
May 14 2022 08:42 AM
This has not yet fixed yet -- creates confusion for the general user -- Kindly rectify this towards user friendly approach