How to set condition for a value that fall within a range.
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 replied
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