Skip to Content
avatar image
Former Member

Formula to Highlighting a field based on part description

I have an existing report and I want to use a formula to highlight the product description in a different color by checking the the 1st char of the product code for the control break.

Is this possible and if so can someone show me the code ?

Many thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 30, 2015 at 12:07 PM

    Hi John,

    Right click the field > Format field > Font tab > click the formula button beside Color and use this code:

    If {product code}[1] = 'x' then

    CrBlue

    Else CRNoColor

    Replace product code with its field name and 'x' with the value you're evaluating it for.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded