1 Reply Latest reply on May 21, 2013 11:20 AM by Shawn Wallwork

    Displaying an achieved target

    Dan Allen

      Hi,

       

      I have a very simple, yet useful text table (shown in screenshot). I also have a simple requirement for this, but I can't work out how to do it. I have searched the forum for conditional formatting but none of them answer my question. I'm sure  it's quite simple to do though....

       

      I would like the value (shown as 98.15%) to have an indication of achievement. Either the text or background change colour, or a circle next to it changes colour so it's coloured something like = <80% = RED; 80-95% = ORANGE; >95% = GREEN.

       

      Any help would be fab.

       

      Thank you