Conditional Formatting

[cbetts75]

Hi,

I've created a report that is based around percentages of returns against despatches.

Now I would like to set some conditional formatting on the report whereas if a rates breaks a certain threshold then the font or background colour will be adjusted. Like a traffic light system.

I've attempted to set this in the report using the conditional formatting option and have set my criteria like so –

Is greater than or equal to – 0.05 (Red)

Is less than – 0.05 (green)

I’ve tried using different numbers (just 5 for example) but to no avail.

Can anyone suggest a fix please?

Please note that the resulting data in the fields is extracted from 3 different calculating queries.

 

[jkl0]

Under your conditions , try using "Expression is" instead of "Field Value is".

 

[edtab]

Can't understand why your conditional format code does not work.
If you have placed an event code in the detail section of your
report, in theory it will work. I've used it before, so I know it works.
On the surface, it seems pretty straight forward.

Perhaps you should post a small db with your report definition so
people could look at it.