changing table box font color based on field value

[sayadutt]

Hi,

I have a table box which contains few columns like below:

column1     column2     column3    

11               AA            Completed

22               BB            In progress

33               CC            Not Applicable

Now i need to have the font colors based on value of column3.

for eg:

if column3 = Completed -> make the font of entire row green

if column3 = In Progress-> make the font of entire row blue

can you please help me to achieve this.

Thanks!!!

[MayilVahanan]

Hi

Try like this

There is no option in table box, use straight chart.

Edit:

Try with this exp: Pick(Match(column3, 'Completed','In Progress'), green(), blue())

[Anonymous]

And, repeat this for every dimension and expression.