conditonal formats.

[jasemilly]

Hi everyone

I have a calculated field and if the value it contains is <=0 I would like the actual text box colour to be red how do I do this?

 

thanks

Jasemilly

[jpauze]

There are a number of threads on here to deal with Conditional Formatting,   as a guide,  check out the help documentation on Conditional Styles or search the formum for the same, the documentation is pretty comprehensive on the subject.   Basically you create a Conditional Style with the expression you are looking for and the color style you want, then you assign the style to your text element and voila,  when the expression evaluates to true the style kicks in and overrides. 

Thanks

Jeff

 

[jasemilly]

I have the styles working showing if a value is good or bad.  But I have a rectangle box across the width of the detail band this alternates between green and white just a nice banding effect.

But the field no longer allows the colour underneath to come through I have played with the opaque tick box but to no difference.

 

I only want the field to be red otherwise I want it to be the colour of rectangle box beneath.

 

thanks

Jasemilly