Different BACKGROUND Color for different rows

[steeramp]

  Hallo everybody,

  How can make differents background color for my column "en%" for  each rows ?

Example :

• for GROUPE 6 , if en% >0  , color Green      ---   if en% <= 0     , color RED
• for GROUPE 3 , if en% >0  , color RED      ---   if en% <= 0     , color Green
• for GROUPE 4 , if en% >0  , color RED      ---   if en% <= 0     , color Green

[vikasmahajan]

HTH

Vikas

[steeramp]

Hmmm no...

I have different condition for each Rows...

[#4]

Hi Steeven.

I think this might work.

in that expression tab, left of en%, click that '+' sign, then click background color, on your right click definition, then write. ohh by the way what is the column that contains your groups(GROUP3,4 and 6), let suppose u called it 'Group', then write

if(Group = 'Group3' & en% > 0,Green(),if(Group = 'Group4' & en% >0,Red(),if(Group = 'Group6' & en%>0,Red(),Green()))).

Hope this helps

[jvitantonio]

Hi,

this can be done from the Background Color expression.

Go to your expression, click on the + signs, and add your conditions in the Background Color option.

I'm attaching an example.

JV

[steeramp · Accepted solution]

Hi everyone,

In this way I have find the solution in the Background Color option

If(rowno(total)=1,If(if en% >0,LightGreen(),LightRed()),

If(rowno(total)=2,If(if en% >0,LightRed(),LightGreen()),

If(rowno(total)=3,If(if en% >0,LightRed(),LightGreen()),

)

)

)