Use conditional formatting.

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


---
HTH

Bob Phillips

"Michelle" wrote in message
...
Hi- I would like to be able to automatically colour code percentages into
red, amber, green depending on the number. I know this can be done but
cannot
figure out how! Any help appreciated