How do I set up a stoplight chart in excel to show % training com

[paul mauro]

I need a stop light chart in excell that will change from red (0-69 percent)
to yellow
(69.1% to 79.9%) to green 80% to 100 %.
Can anyone help?

Thanks

Paul

 

[Pete_UK]

Check out this link to Bob Phillips' site:

http://www.xldynamic.com/source/xld.CF.html#lights

Hope this helps.

Pete