7 Replies Latest reply on Jan 5, 2015 7:13 AM by Matt Lutton

    Have colour on different columns be affected by different formulas

    Niek Dam

      Hi,

       

      Is it possible in a table in Tableau to affect the colour of the information colums, and to let each column to be coloured under a different rule? For example, for an order, I want the cell in the column "Truck arrival" below to turn red for orders where the value in "Truck arrival" is bigger than the value in "Booking" (as in, the truck is late for it's booking). And I want cells in the column "Picktime start" to turn red, if the picking did not start half an hour before the "Booking" column.

       

      Is it possible in Tableau to let the colour of cells depend on a certain formula, and to have this formula be different per column? Basically, I want to use the conditional formatting function of excel

       

      Knipsel.PNG

       

      Thanks.

       

      Niek