Forum Discussion
calvinsaxon
Nov 18, 2021Copper Contributor
multiple rules in format code
Let's say I'm creating a scatter plot chart. So, I've entered in x and y values in the cells. I go to Insert chart, etc., and get the chart displaying just as I want it. Then, I notice there's no 0 d...
calvinsaxon
Nov 18, 2021Copper Contributor
Yeah, if I enter that (three rules separated by two semicolons), it will only add a code with the first two rules, so thanks for the reply but, as always, "works for me" isn't a huge help 🙂
SergeiBaklan
Nov 18, 2021Diamond Contributor
Custom number format doesn't work with more than two conditions, that's by design I guess.