Forum Discussion
hymieho
9 years agoResolver I
Bug: Conditional formatting is filled with a solid color when all values are blank/0
I am using conditional formatting (scales) on a table. When I slice my data in a way that results in all values in the column to be blank, the conditional formatting uses the darkest version of the c...
Eric_Zhang
9 years agoMicrosoft Employee
Thanks for your reporting.
I can reproduce that behavior. I think the reason can be explained, when all 0 or blank, the "Highest value" is 0 or blank, so it shows darkest color, when there's other value than 0, the 0s show the lightest color.