15 Replies Latest reply: Apr 12, 2016 12:07 PM by patrico mesri RSS

    Color background expression when filtering by tables.

    patrico mesri

      Hi Community.

       

      I'm trying to build a "complex "color background expression.

      I have these 2 tables in the same sheet. (The tables have more info.....)

       

      DateDay

      Extra Hours

       

      20/02/2016Saturday80
      20/03/2016Sunday10
      17/01/2016Sunday50

       

      WorkerExtra Hours
      Patrick40
      Leo10

       

       

       

      When I pick the second Table, by Worker, in this case PATRICK. I get the following in the first table.

       

      DateDay

      Extra Hours

       

      20/02/2016Saturday12
      20/03/2016Saturday8
      17/01/2016Saturday4

       

      I need a color background expression that does the following:

      If Saturday extra hours over 4, yellow, over 8 orange, over 10, red.

      The thing is that the color expression should not apply until you pick a worker.

       

      Is it possible?

       

      Thank you in advance.

      Regards.