5 Replies Latest reply on Jul 18, 2016 2:34 PM by Nicholas Hara

    Is there a way to create color codintions based on the cell Values

    Saketh Varma

      I have a worksheet that shows Percentage change compared to a standard, and displays several metrics by day (as in the attachment). How can I color every cell based on the cell value. For example >30% = Green Back ground, >10% light Greeen, <-30% Red, <-10% light red and grey for the rest.

       

      I have looked at conditional formatting but its letting me apply colors to all metrics based on 1 metric values. Please let me know if there is a way to achieve this.

      Screen Shot 2016-07-17 at 9.51.00 AM.png