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