Take a look at

http://www.contextures.com/xlCondFormat01.html

--

HTH

Bob

"DB" wrote in message
...
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