How to colour same cell values in straight table?

[#1]

Hi,

Would it be possible to colour same cell values.

There is column Status in straight table with values as below

Service

Audit

Development

IT

I need the straight table show complete row values with colour Green wherever the Status value='Service'. in the same way Red when Status='Red'

Please can anyone suggest me

Thanks.

[Anonymous]

goto Expression Status and click on "+"

select textcolor or Background color

and enter

if (Status='Service', red())

or you can define any Color using rgb code instead of red()

  advice: use variable which holds rgb code in that case

[maxgro · Accepted solution]

for all dimensions and expressions

=pick(match(Service, 'Service','Audit','Development', 'IT'), green(), red())

[#4]

Thanks. Worked.

[#5]

Thanks.