Custom Cell Formatting

[Barto]

Hi,

I am trying to combine 2 cell formats

The first format is
[>=1000000]$0.0,,"m";[>=1000]$0.0,"k";$0.0

This basically change dollar values in millions to show in the cell $1.3m and cells values in the thousands as $15.6k (instead of showing the full dollar figure


The second format is
[Red][<=-1000000]($0.0,,"m");[<=-1000]($0.0,"k");0.0
Very similar the the first custom format but make the cell font red and incorporates brackets e.g ($1.3m) and ($15.6k)

I want to combine the 2 above custom formats as one cell format that caters for both of the above.

Is it possible?

 

[Drrellik]

Alright Barto,

I am going to bed but I have gotten pretty close.....after several combinations. looking at the custom formatting provided by excel for (RED) vs BLACK I was able to take what you posted and correct it this way.
one for the M [>=1000000]$0.0,,"m";[Red]($0.0,,"m")
and one for the K [>=1000]$0.0,"k";[Red]($0.0,"k")

now I have tried several different way to put these to together but I am missing something I finally got it to work this way without a syntax error
[>=1000000]$0.0,,"m";[Red][>=1000]($0.0"m")$0.0,"k";[Red]($0.0,"k") but it still has bugs.

hope you can figure it out or perhaps the bump will help.


~DR