Color change in single cell

[#1]

My requirement is to change text color  to red where value is negative..But since all the values occur in same cell when i change the text color all three values become red .Only -76.69 should change to red

Expression used is as follow:-

=dual(

num((Sum({<CalendarYear={"$(vMaxYear)"}>}Sales))/(Sum(Total {<CalendarYear={"$(vMaxYear)"}>}Sales)), '0.00%')&chr(10)&''

& '   ' & num(Sum({<CalendarYear={"$(vMaxYear)"}>}Sales), '###,##0')

& '   ', Sum ({<CalendarYear={"$(vMaxYear)"}>}Sales)

) &'    ' & chr(10) & '     '& (num((((Sum({<CalendarYear={"$(vMaxYear)"}>}Sales))

-

(Sum({<CalendarYear={"$(vPrevYear)"}>}Sales)))

/

Sum({<CalendarYear={"$(vPrevYear)"}>}Sales)),'0.00%')

[Colin-Albert]

You can set the text and background colour by clicking on the [+] next to the expression in the Chart Properties, Expressions tab, and then select which parameter you wish to change.

You can use expressions to set different background colours etc.

[Colin-Albert]

Also look at the Visual Cues on the chart Properties