I want compact number(k or Million or Billion) with color as "red" for negative number
For example
[<999950]0.0,"K";[<999950000]0.0,,"M";0.0,,,"B"

1) It should support negative number with paratheses ex: (#)
2) Negative number color should support.
3) It should support positive and negative numbers with compact format.

Ex:
Number
1.23K
3.9M
(2.5M)
5.6B