1 Reply Latest reply on Jul 18, 2013 10:31 AM by Jonathan Drummey

    Conditional formatting on specific fields like excel

    Jessica Cha



      I have a data set and I want to colour code the variance. If it's within |0.02| and 0, then highlight the cell (or text) green, and else in red.

      I've attached an example of what I would like.

      So the ones circled in green are what I want to highlight in green, and so on.

      I looked up conditional formatting and found something similar that involves 'mark', 'bit colour', etc. but I have no idea what I'm supposed to do.

      If not, I guess I will have to do it the old fashion way and export to excel and go from there. >:(


      Thank you!







      So with the help of this thread, now I'm able to colour code all the columns with variance greater than 2%; however, it's affecting my other measure values like paid, difference, etc.

      Is there a way to only limit the colour marks to just the variance row?