Conditional Formatting percent incorrect Excel
conditional-formatting, excel
Solution
When you pick "percentage", this takes the values as a percentage of all the values. Since you're formatting based on the value itself, and not the value as a percentage of all the other values, you need to use 'Number' for the type and use `0.99` for the upper bound and `0.95` for the lower bound.
EDIT: It looks like the behaviour is different in Excel 2016 and one needs to actually put `99` and `95` (and not `0.99` and `0.95`) as values. I guess Microsoft received some complaints or something and decided to change it.
Problem
I have the following: So I want ``` 99% and above = Green Between 95% - 99% = Amber Below 95% = Red ``` However above 95% is still red. Any ideas? Thanks, James