Text color for a dimension

[#1]

Hi,

I have a straight table chart where I am trying to change the text color for one of the dimensions using this:

=if(project_health_code='Green', green (), 'Yellow', yellow (), 'Red', red(), Black ())

Does anyone have any idea what's wrong with my syntax?  If the dimension value is green, I want the text display in green, yellow, yellow, etc. 

This works:

=if(project_health_code = 'Green', green(), Black()) but only for one color/value.

[Anonymous]

Hi guy,

you can use multiple if like this :

if(Sum (val1)='Green', green (), if(Sum (val1)='Yellow', yellow (), if(Sum (val1)='Red', red(), Black ())))

I think that there is a smarter way to do this. I have a look and let you know.

Anyway you could use this for the moment. It might be working.

Regards.

[#3]

Hi,

It said that teh expression was ok but it did not change the color of my text.

[Anonymous · Accepted solution]

you have to change the expression :

don't use my expression, it was just an example.

but use :

if( project_health_code='green' , green(), if(project_health_code='Yellow', Yellow(), if (project_health_code='Red',Red() ,Black())))

regards

[#5]

Thanks, this works.