Can you go into detail on how this specific cell is to be formatted? The
example you gave indicated
[>=10000000]#\,##\,##\,##0;
[>=100000]##\,##\,##0;
##,##0
As far as I can see the format for 100 thousand to 10 million is the same as
the format for under 100 thousand. You can use a single format and rather
than a condition based format you can use the Positive;Negative;Zero;Text