Hi,

Want to change the font color based on condition like when value is negative then display in RED color else display it in BLACK color.
Please note the data type used for this crosstab field is String as I need to display negative value in parenthesis

Example:

 -20 should be displayed as (20) and -45.34 % should be displayed as (45.34%)

I am able to achieve above scenario through “Highlighting Expert” of crosstab field.

Formula used

Value < 0 then font color = red
Value > = 0 then Font Color = Black

But the issue is when the value is not found m retrieving ‘-‘to display in cross tab. Since the field is string, it’s treating ‘-‘in first condition & displaying hyphen also in RED color.

I tried to used below formula in Font tab of “Format object” of crosstab field but m not getting expected result

Formula:
If INSTR ({Value from data table}, “(“) = 1 THEN
 RED
ELSE
 BLACK

Is it possible to display hyphen in Black color?
Please help... It’s urgent…

Thanks,
ThakurS

Actually the problem with formula is "INSTR ({Value from data table}, “(“) = 1 " is not working in cross tab. but the same formula which i mentioned in my previous post was working in Detail section.

This is why i was using Highlighting Expect to achieve this.

Please give me your feedback on how to achieve this.