Forum Discussion
Numer Format Condition Limits
I am attempting to create a new number format which would split my numbers automatically like the following: < 100,000: 0-10000 < 10,000,000: 100 K - 9999 K < 10,000,000,000: 10 M - 9999 M > 1...
Microsoft official documentation apparently does not make it explicit, but you can have only two "condition value" sections (and only three number sections in total) in a custom format. This Tech Community article by Excel MVP Liam Bastick mentions "A number format may contain up to two conditions". (Search for "uninitiated", as he put that text into an image.)
Further down in the article, Liam describes how you can use conditional formatting to work around that limit.