2 Replies Latest reply on Oct 31, 2013 9:37 AM by Matt Lutton

    How can I conditionally format cells within a specific column?

    Alex Mayer
      Categorycurren yearprevious yearIndex
      A1001201.2
      B120900.75
      C1201180.98

       

       

      I want Index column to show as green(conditionally format) when it's greater than 1, red when it's less than 0.95 and yellow when between 0.95-1.

       

      1.2 should be Green, 0.75 red and 0.98 yellow.