Custom Text Formatting in thousands and millions with red up arrows and green down arrows

[rollnation2]

Hello,

I am trying to add custom text formatting that displays in thousands and millions with the conditions below:

• red text, with an up arrow for positive numbers
• green text, with a down arrow for negative numbers

Here are a couple of examples, hoping for a single text format that recoginizes negative number as green and formats them exactly as below.

Example for thousands increasing number - Text Format:"[Red]$0,"K" ▲;[Color10]$0."K"▼;"-""

Example for millions increasing number - Text Format: [Color10][<999950] 0.0,"K" ▲;[Red][<999950000]0.0,,"M"▲;0.0,,,"B"

Example of what does not work
[Color10][<999950] $0.0,"K" ▼;[Color10][<999950000]$0.0,,"M"▼;0.0,,,"B"

- I would want this to be green with a down arrow

Any help would be appreciated!

 

[Dan_W]

- I would want this to be green with a down arrow

That's exactly what it does for me:

 

[Dan_W]

Sorry, if what you're actually after is to make sure that it has the negative sign before the numbers, that's easily solved:

[Color10][<999950] "-"$0.0,"K" ▼;[Color10][<999950000]$0.0,,"M"▼;0.0,,,"B"

 

[rollnation2]

Dan - thank you for the help!

Is there a way to combine the text code into a single line so it recognizes negative and positive values and formats them to I do not need different format codes for negative and positive values?
I dont need a negative sign. Just want negative values showing Green with a down arrow and positive values showing Red with an up arrow.

I dont need a "billions" format code, only millions as "M" and thousands as "K".

Thanks for your help!