1 2 Previous Next 15 Replies Latest reply on May 1, 2019 7:52 PM by Zhouyi Zhang Branched to a new discussion.

    Conditional highlight based on other column

    Sophie Hong-Dunnett



      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.



        1 2 Previous Next