custom color formatting

[catchingup]

I'm using a formula on a field in CR11 to display several different colors depending on the value.
Does anyone know of a way to use a custom color (or multiple custom colors) in a conditional formula?

(ie: if {fieldx} = "y" then crRed}
Any help is appreciated!!

 

[lbass]

You can use:

color(r,g,b)

...for custom colors, where red, green, and blue components are numbers varying between 0 and 255, or use crred, crBlue, etc.

You can use an if-then or a case statement, as in:

select {table.field}
case "y" : crRed
case "b" : color(255,255,100)
case "c" : color(100,200,100)
case "d" : crGreen
default : crNoColor

You would enter this in format field->border->coclor->background->x+2 to color the background of the field.

-LB