How to set condition for a value that fall within a range.

[Former Member]

Hi,

I have a parameter and value should fall within the range 6 to 8. Value should be highlighted if it does not come in between this range

How can I set this condition is font style . I have other parameters as well in the report. All these parameters have different conditional values. This is a cross tab report.

Can I define this conditions in a formula field. If yes, how can I call in the font/style tab to set the condition.

Please Advise.

Jessy.

[abhilash_kumar · Accepted solution]

Hi Jessy,

Right-click the crosstab cell that you'd like to be format > Format Field > Font tab > Click the formula button beside Color and use this code:

If Not(currentfieldvalue IN [6 to 8]) then

crRed

else

crNoColor

-Abhilash