Forum Discussion
Conditional formatting is not following simple rules
Hi! Conditional formatting has been bugging me for months. I have a KPI that I make a nice overview for once a month, where I want the following to happen: If the cell has a value at or above...
Afraid you miss source data type and rule settings in percent. Let say you have 3 values: 49%,70%,80%.
When you say to apply green icon to values with more than 66 with type percent, you say that all values which are more than or equal to 49%+(80%-49%)*.66 `(which is equal 69.46%) will be with green icon.
That means 70% will be green and 69% will be yellow.
If your cell values are in per cents, easier and more convenient in conditional formatting rule use type Number and set rule as >=0.66 for green icon, rest are similar.
When in your source data 66% will be green and 65% will be yellow.