5 Replies Latest reply on Aug 19, 2016 6:23 AM by Rajeev Pandey

    How do I highlight rows that contain the word "Not" ?

    Louisa Kho

      I have a set of data - Comments on hotels for my project and I would like to highlight rows in which the comment contains the word "Not"

       

      I have attached the data file (hotel data)

       

      I tried watching Youtube videos on "Conditional Color formatting" (Tableau: Advanced Conditional Formatting - YouTube ) and tried doing it own my own and this happened :

       

      First, I created this calculated field :

       

      IF CONTAINS([Comment],"Not") THEN "Color"

      END

       

      Then, I tried putting the "Highlight" in the colors mark and this happened :

       

      I tried using other ways to do it but it seems that only the second column is affected which I'm not sure why.

       

      I would like my tableau to be highlighted when it contains "not" which would look something like this :

       

       

      Thank you.