Forum Discussion
Conditional Formatting an Average Column in a table
Hi bhard ,
You problem here is a question about format of the numbers you input in your rule, being a percentage the values are all in the 100 base so instead of making it the percentage value 0 - 50, 51 - 85 and 86-100 you need to select the numbers and make them until 1.
In this case you need to select the 0 - 0.5, 0.51-0.85 and 0.86 - 1 and change the percent to number.
This will return the correct value.
The percetage that you see using the rule is the percentage of values meaning that for the first rule the values that are in the first 50% of the calculations get the red colour. so that is why the to lowest values are marked because you have 4 values so 50% is 2.
Hi bhard ,
You problem here is a question about format of the numbers you input in your rule, being a percentage the values are all in the 100 base so instead of making it the percentage value 0 - 50, 51 - 85 and 86-100 you need to select the numbers and make them until 1.
In this case you need to select the 0 - 0.5, 0.51-0.85 and 0.86 - 1 and change the percent to number.
This will return the correct value.
The percetage that you see using the rule is the percentage of values meaning that for the first rule the values that are in the first 50% of the calculations get the red colour. so that is why the to lowest values are marked because you have 4 values so 50% is 2.