Forum Discussion

inglexjc's avatar
inglexjc
Icon for Post Patron rankPost Patron
3 years ago
Solved

Color coding with Multiple Colors with Multiple Text in same column

I have a table called 'Legal Files' column name is Description_1 (Visual shows Description).   I was able to color code when "Letter Waived" is in the column to show the font as BLUE.  But now it's...
Need Help
  • Padycosmos's avatar
    Padycosmos
    3 years ago
    Color =
    VAR col = SWITCH(TRUE(),CONTAINSSTRING(SELECTEDVALUE('Legal Files'[Description_1]),"Letter Waived") || CONTAINSSTRING(SELECTEDVALUE('Legal Files'[Description_1]),"Dispo"),"Blue", CONTAINSSTRING(SELECTEDVALUE('Legal Files'[Description_1]),"Person") || CONTAINSSTRING(SELECTEDVALUE('Legal Files'[Description_1]),"WebEx"),"Red")
    RETURN
    col
inglexjc's avatar
inglexjc
Icon for Post Patron rankPost Patron
3 years ago

Padycosmos this does not help.  Watching the video it has to do with numbers and doesn't translate to text.  Also in the video the numbes are not in the same Column they are in differnt rows.

 

I need color coding for TEXT in the same Column.

Padycosmos's avatar
Padycosmos
Icon for Solution Sage rankSolution Sage
3 years ago

I understand. Please try changing the format style to Field Value as shown below

 

  • inglexjc's avatar
    inglexjc
    Icon for Post Patron rankPost Patron
    3 years ago

    That's not working either.

    • Padycosmos's avatar
      Padycosmos
      Icon for Solution Sage rankSolution Sage
      3 years ago

      In the conditions, you can use the conditions  "Person" || "Webex", 3, "Letter Waived" || "Dispo",1

      • inglexjc's avatar
        inglexjc
        Icon for Post Patron rankPost Patron
        3 years ago

        Padycosmos in the youtube video you sent it's using 

        How do I convert this when I'm not using numbers?  What formula should I be using in order to get the conditional formating to work?