11 Replies Latest reply on Jul 30, 2012 2:20 PM by Wolverine .

    How do I carry out conditional formatting on a text table

    Susan Anderson

      I have a text table with 3 measures - the 3rd measure being a difference column (i.e measure A - measure B gives you the difference).  I want to background shade the cells that show a difference of negative as say red, and positive as say green.  I can "almost" do this with a highlight table but can only display 1 measure.  I want to display all 3 measures but only conditionally format the difference column.  I have seen lots of posts of this but am wondering if I am perhaps missing something as this seems like it should be possible?  Any ideas much appreciated.