If cell c6 says: ---------------------------- I would like to
have D6 automatically say

Approved ---------------------------- 25%
or
Design ---------------------------- 50%
or
Build ---------------------------- 75%
or
Shipped ---------------------------- 100%


Any Ideas????

Thanks

John


--
John Doe
------------------------------------------------------------------------
John Doe's Profile: http://www.excelforum.com/member.php...o&userid=26826
View this thread: http://www.excelforum.com/showthread...hreadid=400756