Force negative numbers in red

[Anonymous]

Hello,

I'd like to keep the negative numbers in red color when I change the font color using the "Text Color" proprerty; in other words, I'd like to change the font color in an expression only for positive numers.

The formula I set in the Text Color property is something like that:

If(Condition1,Green(), Yellow())

Can I set the red negative numbers formatting in the Format Pattern setting something like this?

€ #.##0;[red]-€ #.##0

Thks.

N.

[Colin-Albert]

The format pattern can change the format of negatice numbers e.g. -123 or (123), but does not change the colour. You will need to use the Text Colour property on the expression by clicking [+], or use Visual Cues

[Anonymous]

...I've tried to follow the suggestion, but the Visual Cues options are overwritten by the Text Color option in the expression, so I can't use them.

Using the Text Color option in the expression, I'd like to know how it is possible to set them testing the Expression Formula without replace it into the Text Color Formula (so that I shouldn't manage the same formula in two different places).

Hope it's clear...

Thanks.

N.

[rubenmarin · Accepted solution]

Hi, you can use the column name, or the Column() funtion, ie:

If([Column Name]<0, Red(), Green())

[Anonymous]

Thank you so much. 🙂

N.

[vikasmahajan]

if you are using straight table you can use visual cues  please see attached image.

HTH

Vikas

[Anonymous]

I know it, Vikas, but the Visual Cues is incompatible with the Text Property set into the Expression: e.g if I set the Text property of the expression as White() and I set the negative numbers in Red when they are negative into the Visual Cues, they will apper always white!

N.