Color an individual cell in a table

[#1]

Hello,

I recently exported a table from excel into qlikview and i am trying to color each invidiual cell depending on the value.  If the value = 1, it should be green and if the value = 2 then it should be red.  I tried doing this but it colors the entire table instead of the individual cell.  How would i go about doing this where it only colors an individual cell.

Thanks,

[morganaaron]

Hi Brandon,

On the expression tab, on the expression you've created that shows 1 or 2, if you click the + sign on the left and click on the 'Background Color' option, it should allow you to type an expression into the definition box.

What you'll want is an expression along the lines of if([your expression]=1,Green(),if[your expression]=2, Red(),)) that will colour it depending on your results. You could use a Match statement or similar idea to get the same result!

[rajeshvaswani77 · Accepted solution]

Hi Brandon,

You can go to User Preferences, Design tab and check Always show design menu items.

Next go to a table, right click the cell and say custom format cell. Here you can color the cell.

thanks,

Rajesh Vaswani

[its_anandrjs]

Hi,

If it is dimension the try with click on the plus sign and in Background write

BackGround

=if(FieldName = 1 ,Green(),Red() )

Text Color

White()

Regards

Anand