Conditional text vale background color for text object?

[devarasu07]

Hi,

I've below rule and tried to apply conditional value background color and it's not working. any suggestion. tks

if(Definition='Ideal',rgb(204, 255, 204),

if(Definition='Average',rgb(255, 173, 51),

if(Definition='Below Ave',rgb(255, 173, 51),RGB(250, 128, 114))))

[tresesco]

One text box can't have multiple bkcolors. I guess, you are trying to represent this colors as legends, if so, you could simply use four text boxes with static color and text on it.

[effinty2112 · Accepted solution]

Hi Devarasu,

Maybe  a straight table like this:

Dimension:

=ValueList('Ideal','Average','Below Ave')

No expression, uncheck Suppress Zero Values and check Horizontal in Presentation tab.

Dimension label - Definition:

Dimension Background Color:

=Pick(Match(ValueList('Ideal','Average','Below Ave'),'Ideal','Average','Below Ave'),

RGB(204, 255, 204),

RGB(255, 173, 51),

RGB(250, 128, 114))

cheers

Andrew

[effinty2112]

Hi Devarasu,

Here's a correction to earlier post that ignored the Critical definition:

Dimension:

=ValueList('Ideal','Average','Below Ave','Critical')

Dimension Background Color:

=Pick(Match(ValueList('Ideal','Average','Below Ave','Critical'),'Ideal','Average','Below Ave','Critical'),

RGB(204, 255, 204),

RGB(255, 173, 51),

RGB(255, 173, 51),

RGB(250, 128, 114))

cheers

Andrew