Forum Discussion
Excel Tip: Simple Custom Numbers Formatting Based on Their Sign
With the Method shown in the video, you do not need to resort to conditional formatting. Just go to Format Cells :: Custom and input your formatting rules: i.e.: [blue] 0,00 " kg" ; [red] (0) " km"...
Hi there, thanks for the question. For that you DO need conditional formatting, at least as far as I know.
Your example is a perfect candidate for conditional formatting 🙂
The thing about this hack is that you can quickly type it in. Wehn more complex formats are required, I would turn to conditional formatting.
Interesting.
So custom formatting hacks can do simple things with complexity.
While conditional formatting is required to do complex things simply.
I like the symmetry!!