3 Replies Latest reply on Feb 7, 2014 5:19 AM by Matt Lutton

    Conditional Formatting by dimension

    Anuja S Krishnan

      I have a crosstab listing a few measures (averages) in rows and one dimension dragged to the column shelf. I am trying to shade cells based on certain conditions, I would like to provide a different condition for each column/dimension.

       

      I am attaching a sample workbook here. The "Average" tab contains the crosstab I am working on. I want to color cells in "China" column based on a condition, may be GREEN for > 3.00 and RED for < 2.50. Then, for the "India" column, I would like add a different condition. Is this possible?