9 Replies Latest reply on Jul 19, 2013 1:07 PM by Jason Back

    Conditional Formatting Color

    Jason Back



      I am looking to implement conditional formatting in color to data table and struggling where to start.


      As example image attached, I'd like to color cells (if not possible texts) for each Sales Index and Profit Index column by store


      Comparing numbers 2013 data to 2013:

      -  If >0 then in Green

      - if between ->=-3 and <=0 then in Yellow

      - if <-3 then in Red.


      I've attached the file alng with 2012 data as well as the final product how I'd imgained to be.  Any suggestions would be much apprecaited.  Thank you.