Forum Discussion
Matrix Conditional Formatting when all values are zero
Hello, I'm using conditional formatting in a matrix to set the background color based on color scale. However, when all the values in the column are zero (not null or blank), the color defaults t...
For you and anyone else finding this, these are the settings that I was able to configure that fixed this issue for me today. Add a middle color with a custom value of 1. Move the previous lowest color of the gradient to the middle color and set the Lowest Value to #FFFFFF or whatever you want that 0 to show. Empty values setting is irrelevant, but I set it regardless.
If this was helpful, let me know. If it doesn't work, let me know that too. Seems like a mixed bag.