How can I apply a color scale format to a column, and apply another format if a cell has a certain value?
For example, these values would be red, yellow, or green depending on its value, but a zero value would have a white background:
1231
34
0
324
6456
AFAIK there is no way to set up a color_scale_CF for a range of cells except the zero-values.
If the white background is intended to hide zero values, you can hide them away completely. See Tools>Options>Calc>View
Thanks for the suggestion, but I want to hide the zeros on some spreadsheets, not globally on all. And it still leaves the background red. I’d really like it to be white.
four conditions != colorscale except for zeros
1 Like