Skip to Content

Formula to change font color

I'm trying to write a conditional formula by right-clicking the formula field InsCoGrowth2013-2014 > Font > Color X-2 formula box >

If {@InsCoGrowth2013-2014}<0 Then crRed Else crBlack

The error message I receive 'A string is required here' and the 0 is highlighted.

The formula, InsCoGrowth2013-2014, returns a percentage. 

Thanks soooo much!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 02, 2015 at 07:52 PM

    Hi Rich,

    Try:

    If CurrentfieldValue = '0' then

    crRed

    else

    crBlack

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • What color do you want this formula to return when the other formula returns 'N/A'?

      This should work:

      If currentfieldvalue = 'N/A' then

      some_color_of_your_choice

      else

      If ToNumber(Trim(Replace(CurrentfieldValue,'%',''))) < 0 then

      crRed

      else crBlack


      -Abhilash