Color in particular column of stright/Pivot Table

[#1]

Hi Experts,

How to have a color in particular column of a table.

For Ex: If the value of that column is "Yes" then Green color else No Color.

[mato32188]

Hi, use Visual Cues in Chart Properties by setting up your value or click on expansion button in Expressions (Chart Properties) and set up Background Color by If statement using the RGB function.

Regards, M

[bertdijks · Accepted solution]

You can use the background option in the variable, see the next example:

Hi,

Kind Regards,

Bert

[#4]

In expression select the background color,then

try the following expr:

=if((your expr)='YES',green())

[#5]

Thank you Martin

[#6]

Thank you Bert. It's Working.