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