Showing negative values in red color

[Newbie777]

Hello,

I'd like to show negative YOY % difference in red color and I used the following formula, but it is not working. 

I'd appreciate it if anyone could let me know why after applying the formula below, all the values are still being shown in black including the negative values.  

Thanks you for your guidance.  

[saniyask · Accepted solution]

Hello,

Can you try again with the square brackets instead of single quote.

Eg:- IF([Sales]<0,Red(),Green())

Regards,

Saniya

[Newbie777]

Thanks for your response, I tried, but it shows an error message.  Does it have something to do with the fact that I only changed the name of the measure and the measure expression itself is much longer than the simple labeling I used below?  

[Newbie777]

Thanks.  I replaced the measure with the original measure expression, and it worked.  Thanks for pointing me in the right direction.  

[NormanStanleyBadger]

You can reference a measure using this - "Measure Name" (note the double quotation marks) 

The evaluation box will still throw out an error message but it will work.