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.
Sorry you're having trouble with the forum search. Here's a link to a whole lot of information about conditional formatting both on and off the forums. The bottom of the page has an extensive list via Jonathan.
Oops here's the link: http://drawingwithnumbers.artisart.org/?s=conditional+formatting