9 Replies Latest reply on Jun 5, 2019 12:06 AM by Zhouyi Zhang

    conditional colouring help

    Daryl Cox

      Morning

       

      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

       

      thanks

       

      Daryl