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...
Hi Anonymous
Change this feild to don't format instead of "As Zero"
This only works for null or blank values. As I mentioned in my question, it does not apply if my values are zeros.
Just out of curiosity did you try using Custom like here
Yes that was the last thing I tried before posting here, which didn't work unfortunately.