Change font for negative numbers across report

• TB-462197

  SSC Eights!

  Points: 990

  More actions

  May 2, 2008 at 10:50 am

  #186090

  I know for any given field in the report, I can make change the font color using expression like

  Iif([FieldBeingUsedInThisCell].value < 0, [make the color red],[otherwise don't])

  (great formula, right?) 😉

  My question is this:

  How do I apply that across the report without having to specify which field is being used?

  Meaning, something like:

  Iif([whateverthisvalueis].value < 0... etc...

  Thanks!

• TB-462197

  SSC Eights!

  Points: 990

  More actions

  May 2, 2008 at 3:43 pm

  #810361

  Figured it out:

  =Iif(me.Value < 0,"Red","Black")

  I've never used "me.Value" before-- neat trick!