Hello all
I am having some issues with formatting my numbers. I have my range in millions from +5M to -5M in my data set (see attached worksheet).
I can get the positive # to appear as i.e. $4.1M but anytime the value is negative million, it just comes at i.e. -$1,308,316 (I would like to show as "red" ($1.3M)
How can i get the brackets to be added and for it to show in red - below is my format > customer # format
[>1000000]$#.0,,"M";[>1000]$#,"K";$#,##0
Also, if it less than M, I would like the value to auto adjust to show i.e. $198K or "red" ($140k)
any help would be appreciated!
Bookmarks