Hi'

Let's say these results are in c1 to C10. Select those cells and then

Format|Conditional format - Select 'Formula is' from the dropdown and enter
the formula

=C1=0.8
Click the 'Format'button and select Amber Ok

Click add and repeat the above but this time use the formula

=C1=1 and pick Green

The formula will 'adjust' for the other cells you have selected.

I have assumed E2003. The process is slightly different for e2007 but the
formula are the same


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"DB" wrote:

Im trying to set up a small chart at work using excel. We get targets and we
then have to input our actual achieved figures......

What I'd like to do is set it so that if wee achieve 100% or more the box
turns green...... if we achieve 80% + then it shows an amber colour........
and if below that then its a red colour...

I,ve tried allsorts but cant quite suss this task out.

Yor help will be very much appreciated.

DB

.