Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
for all dimensions and expressions
=pick(match(Service, 'Service','Audit','Development', 'IT'), green(), red())
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
for all dimensions and expressions
=pick(match(Service, 'Service','Audit','Development', 'IT'), green(), red())
Thanks. Worked.
Thanks.