background colour dependent on numerical value

[Ric]

I would like to be able to have the field background be dependent on the numerical value in the field for example if the value was >90 the field background would turn red...if vaule >80 background=blue...

[Ugo DI LUCA]

Hi Ric,

That's where I'll use containers.

Even with 2 colors.

create a global field called red_highlight (multivalued, 2)

create an unstored calculation (container format) =

Highlight = Case (yournumberfield >90, GetRepetition(red_highlight,1), yournumberfield >180, GetRepetition(red_highlight,2),"")

Draw your colors in a rectangle (no borders)

Copy (in Layout mode)/paste (in Browse mode) into the different repetitions.

Drag that new field on your layout and set it with same size as your number field.

Set the image (see format for this).

Place it back of your field.

Make your number field transparent.

That's it.

[Ugo DI LUCA]

OOOps

Case (yournumberfield >80 and yournumberfield<90, GetRepetition(red_highlight,1), yournumberfield >90, GetRepetition(red_highlight,2),"")

Use as many colors as you want....