How not to color scale if cell is 0

[Salegan]

Hello,

I have 3 collumns with a result (%win, %lose, %draw) color scaled (red, green, yellow) and another same 10 rows under it. Is there a way to not color scale cells with result 0? Using 1 conditional formatting to color scale and 2nd condition formatting with rule for white background always leaves only the color scaling color. I have uploaded the file in question, 1st sheet.

Thank you.
Successors - battle probabilities.ods (596.1 KB)

[karolus]

Hallo

1. Dont see zero-values in your example???
2. CF resolves in the order the Conditions applied … (first True Condition wins ) !!! …
3. … except for the SPECIAL-conditions (Colorscale|Databar) which can NOT supressed by earlier|later Conditions in the chain

[LeroyG]

As a workaround:
F8: =IF($'2k6 x 2k6_4x3'.R2=0;"0.00";($'2k6 x 2k6_4x3'.R2=0))
The 0.00 between quotes are text, so there is no color applied. You could right aling.
Take note that text don’t work for statistical (and other) functions (i.e., AVERAGE).