Change Color Background depending on Value List

[snatkins]

Hi,

Is there a way to change the background color of a field according to its Value List? I have a field: STATUS with VL (Available, Consigned, SOLD) and I would love it if the field could be colored RED when Status = Sold

Thanks, Sarah

[David Holmberg]

What you can do is to place a calc field behind your status field (which has to be set to transperent)

Then you have to create a container field with your bg pictures

Define the calc field (which have to be set to container result):

Case(

Status="sold";

GetRepetition(containerfield;1)

;

GetRepetition(containerfield;2)

)

...there are many threads about this subject, so if my post isn't clear enough you can just do a search.

Hope this helps you

[Mark Jones]

This isn't working in my situation it says "need another operator". Green and White is a Global container field Elk contains a x and if there is a x I want the container field to be green. What am I doing wrong here.

Case ( Elk ; "x " ; GetRepetition(green);GetRepetition(White)

[BobWeaver]

Case ( Elk = "x" ; green;White)