10 Replies Latest reply on Jul 2, 2019 6:45 AM by Daryl Cox

    conditional colouring help

    Daryl Cox



      I am struggling to get the result i require when trying to colour the background of a column based on values within the previous column


      basically the table within the packaged workboom is shown below


      i am looking to colour the last column 28/01 based on the value in column 21/01


      so for Aberdeen depot 21/01 = C and 28/01 = B

      in this scenario a B is better than a C so would like to show this as GREEN


      For Amesbury both values are a C so do not want to colour at all

      For severnside the 21/-1 = 21/01 = E and 28/01 = F

      F is worse than E so would like to show this as RED


      Is this possible at all