1 2 Previous Next 18 Replies Latest reply on Mar 21, 2014 12:43 PM by Matt Lutton

    Need help changing a cells color instead of the entire column

    Jean Jacques Potgieter

      I tried using a conditional color mark to change the text color of a cell. The colors change, but it's changing the entire column when I just want a particular cell to change. tableau5.JPG.jpg

       

      I'm just trying to change the values in the Zaps row, but it changes the entire column. The formula I'm using is:

      IF [Zaps]>5 AND [Zaps]<10 THEN 'ORANGE'

      ELSEIF [Zaps]>=10 THEN 'RED'

      ELSEIF [Zaps] == 0 THEN 'BLUE'

      ELSE 'BLACK'

      END

       

      Thanks in advanced.

        1 2 Previous Next