Try this, Ravi:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=319
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Ravi" wrote in message
...
Hi,

I use excel to keep track of my sales leads. Ideally i would like a nearby
cell to show graphically the status of the lead when i enter the values
(conversion probability) in the adjacent cell.

Can someone help. I should probaly warn that i am no good with macros.