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 ,
Does your problem have been solved? If it is solved, please mark a reply which is helpful to you.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
This does not solve my problem because the maximum values are not known. I would still like the largest values to be dark-colored, and the smallest values (zeros) to be light-colored.
If all values become zero, the color displayed is darkest, not lightest, which is not desirable.