9 Replies Latest reply on Sep 17, 2018 4:00 PM by Shinichiro Murakami

    Conditional Formatting in Tableau

    Sandeep Verma

      Hello All,

       

      I have two table in excel sheet as shown below:

       

      Table1:

      Table1.PNG

      Table2:

       

      Table2.PNG

      I have created a table using table 1 in tableau as below:

       

      Capture1.PNG

       

      Now in this table, I want to color the cell values for each measure values based on the other table:

       

      >=Goal : Green

      <=Trigger : Amber

      <=Limit : Red

       

      if credit

      >=Goal : Green

      <=Trigger : Amber

      <=Limit : Red

       

      similar for other measure values.

       

      Please help me to solve this problem.

       

      Thanks

      Sandeep