saboh12617
New Member
- Joined
- May 31, 2024
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
Hello everyone,
I'm a bit new to number formats and i discovered today you can apply conditions on the value of the cell to modify it's format directly in the "custom" format formula.
However it seems i am doing something wrong because, as an example, this works :
But if i add a 4th condition like this, it does not work anymore
Is it related to the 4 cases (between ";") of the formula?
In this case i guess, as suggested in this excellent article (Custom Excel number format), it is better to use conditional formats, but i wanted to understand why i was getting an error at the 4th condition ?
Thank you for your time
I'm a bit new to number formats and i discovered today you can apply conditions on the value of the cell to modify it's format directly in the "custom" format formula.
However it seems i am doing something wrong because, as an example, this works :
[Blue][<1000000]0;[Green][<1000000000000]0;[Red]0
But if i add a 4th condition like this, it does not work anymore
[Yellow][<1000];[Blue][<1000000]0;[Green][<1000000000000]0;[Red]0
Is it related to the 4 cases (between ";") of the formula?
In this case i guess, as suggested in this excellent article (Custom Excel number format), it is better to use conditional formats, but i wanted to understand why i was getting an error at the 4th condition ?
Thank you for your time