Changing color of text based on result

[wilekoyote76]

I am trying to color code results from a formula. The formula is a local formula and the results are calculated and vary on every record accessed in the Details section of the main report.

Is there a way to color code from within CR11r2 other than under the formatting formula section, like within the formula itself or set a variable that can be accessed by the formatting formula section for every record.

 

[wilekoyote76]

Click on Insert Summary. Select if you want a Count for whichever section or the Total for everything and your solution is found

 

[wilekoyote76]

Wrong forum. Sorry. Still need the answer to this if there is one.

 

[lbass]

What is the problem you are encountering? What is the content of the formula? Why not just use the format field->color->background->x+2 formula area to set the color? e.g.,

if currentfieldvalue < 5 then
cryellow else
if currentfieldvalue < 10 then
crgreen else
crnocolor

-LB