Skip to Content
avatar image
Former Member

Show result in Colors

HI I have a formula

If ({Diagnosis_Codes.Diagnosis_Code} IN ['V20.2', 'Z00.129'])
Then
'Well Visit'
else
'No Well Visit'

And we display it as max. The users want 'Well visit' should be in green whilst no well visit should be Red. Is the only way that I make a variable with this colors?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 12, 2016 at 02:36 PM

    Hi Paul,

    Right-click the formula field on the section > Format Field > Font tab > Click the formula button beside 'Color' and paste the code in here.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 08, 2016 at 11:00 PM

    Hi Paul,

    You'll have to do this in the format editor. Right-click on the formula and go to Format Field. In the Font tab tab, click the formula button beside Color. In there you can create a formula like:

    If {@myFormula} = "Well Visit" Then 
        crGreen
    Else crRed; 

    Good luck,

    Brian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Brian, it doesn't do the green for all of them. And not when the patient has more than one 'Well visit' it only greens the first one the others are red.

  • Dec 09, 2016 at 08:24 AM

    Hi Paul,

    You can also use:

    If currentfieldvalue = "Well Visit" Then 
        crGreen
    Else crRed;
    
    Add comment
    10|10000 characters needed characters exceeded