Visual cues for text values

[#1]

Hi:

I want to show green,red and yellow colors based on the text values.

If say status = G, display the cell in green color

if the status = R,display the cell in red color

If status = Y, display the cell in yellow color.

I have created straight table and used G,R and Y as expression since visual cues work only with numeric values

but cannot get the respective colors for G,R and Y.

Since Visual cues work only with numeric values, i have also tried to put the following in the expression

if (Status = 'G',Green(),red ())

or

if (Schedule = 'G',RGB(0,128,0),red ())

but not getting the right result.

Can you please help.

[shree909]

Hi,

when u go to the expression  u fiond a '+' sign , when u expand that u will see options to change the

1)text format

2)Text color

in text color u write the expression

if (Status = 'G',Green(),

if (status ='R' , red(),yellow())

[jagan · Accepted solution]

HI,

PFA file hope it helps you.

Regards,

Jagan.

[MayilVahanan]

Hi

In the expression tab, you can see the '+' sign. By  clicking it, you can see background color, text color.. According to your requirement, choose any one of them, and put the expression like this

if (Status = 'G',Green(),red ())

hope it helps

[#5]

Thank you all.

It worked.

Thanks for the sample.