I am looking for a single format string to apply entire column which may contain +ve or -ve numbers.
1) show compact number with K, M, B.
2) apply parenthesis to negative number. ex: (#)
3) apply color to negative numbers.
I could do with individual format string as below:
+ve nbr format: [>=1000000]$#.0,,"M ";[>=1000]$#.0,"K ";$#,##0.0
-ve nbr format: [Red][<=-1000000]($#.0,,"M");[Red][<=-1000]($#.0,"K");[Red]($#,##0.0)
It is very cumbersome to apply this format to individual cell.
