Color Formatting based on mutiple values 1

[epoh]

I have a formula with several conditions that I would like to format the text color if only a couple of the conditions are met.

How can this be done in the formula workshop, note i cannot use the highlighting expert because i am concatenating two fields together and adding explanatory text, so there is never a consistent value.

Thanks

 

[vidru]

Version? Oh well, this is for XI...

Right click your formula field on the report canvas > Format Field > Font tab > next to Color, click the conditional formula button [x+2]. Then write a formula that returns the proper color constant based on your conditions:

if {Table.Field) = 1 then
  crRed
else if {Table.Field) = 2 then
  crNavy
else if {Table.Field) = 2 then
  crGreen
else
  crBlack;

-dave

 

[epoh]

Sorry for not stating which version. Yes CRXI Dev.

That worked I just was trying to do it in the wrong area.

Thanks.