I'm trying to control the display of Excel cells using the customized format.
For example
#,##0;(#,##0)
will shows positive numbers as usual, but negative numbers with brackets instead of with a -
sign.
Where can I find the introduction of the syntax? For example, I don't know how to make negative numbers to show as red. Also, I'm not sure how to specify the precision.