How can I made the cell red when value is negative?

[carter_zhou]

I'm a beginner ,How can I made the cell red when value is negative?

[pumaking]

Hello,

you can use conditional styles for that. Therefore you need to create a parent style first (Report inspector/Styles). Then you create a conditional style with the formatting options that you like.

In that conditional style you can use an expression like $F{FIELD}<0 . The problem is that as far as I know you cannot reference to the textfield value itself, you always have to use a specific field. So you need to create a conditional style for every field that you want to be conditionally formatted.

After doing this you have to apply the newly created style to your textfield.