13 Replies Latest reply on Aug 20, 2018 4:32 AM by Zhouyi Zhang Branched to a new discussion.

    Conditional highlight based on other column

    Sophie Hong-Dunnett

      Hi,

       

      I am trying to format one of the column (Hours) so that it's rows displayed different colour depends on a condition on the Expected Hours column.

       

      Sample columns as below:

       

      Hours                              Expected Hours

      152                                  160

      123                                  150

      30                                    20

      160                                  160

      130                                  120

       

      The condition is as below:

       

      If Hours > Expected Hours then "Green" elseif

      Hours < Expected Hours then "Red" else "Black" End

       

      I read a bit on conditional formatting but I could not find example on how to do this depending on the result from another column.

       

      Any suggestion would be much appreciated.

      Thanks

      Sophie