How to change the field color of a table based on a value

[#1]

Hello everyone,

I have imported an excel table into a Qlikview table and it is filled with the values 1 or 2.  I would like every value thats a 1 to have the entire field be filled green, and every value thats a 2 be filled green.  How would i go about doing this?

Thank you

I am using Qlikview 11.2

[Anonymous · Accepted solution]

Hi Brandon,

use below code in background color option of dimension:

=If(value = '1',LightGreen(),LightGray())

Regards

Neetha