4 Replies Latest reply on Jan 12, 2017 6:07 AM by John Sutton

    Color Formatting By Column

    John Sutton

      Hey all,

       

      Looking to be able to format by individual columns in the attached workbook. I currently have it set to where if sales are lower than the previous month before it, then it will highlight red. Conversely if sales were better it will highlight green; and if stagnant it will highlight grey. However it's applying this formatting to all the columns rather than just the sales column exclusively. I'd like to be able to apply 3 different color patterns to each solumn.

       

      E.g. Sales for October 2012 are down compared to September 2012 so October 2012 will highlight red, but Margin is stagnant compared to September so margin will highlight grey rather than the red it is highlighting due to the format from the sales.

       

      I've attached a packaged workbook - hoping for some help!