Forum Discussion
Conditional formatting not working when filter with a slicer
Anonymous You need to use 'number' not 'percent' in your conditional formatting:
Percent refers to the total number of values, so when you have a filter with only 1 value, that single values makes up 100% of the number of values.
When you have a filter that filters down to 2 values, a single value is 50% of the total number of values, so the greatest one would be highlighted in green (at 100%) and the lower one would be at 50%.
When you have 3 values, they each account for 33% of the total number of values,
and so on.
Hope that helps?
Anonymous You need to use 'number' not 'percent' in your conditional formatting:
Percent refers to the total number of values, so when you have a filter with only 1 value, that single values makes up 100% of the number of values.
When you have a filter that filters down to 2 values, a single value is 50% of the total number of values, so the greatest one would be highlighted in green (at 100%) and the lower one would be at 50%.
When you have 3 values, they each account for 33% of the total number of values,
and so on.
Hope that helps?