Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 07, 2016 at 04:31 PM

    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

    Add comment
    10|10000 characters needed characters exceeded