You said it was a drop down list? How many items are in this drop down list
and when do you use those items, and on what conditions? Maybe you need to
use a conditional format?
Arla

"Neo1" wrote:


But the cell i want it to be changed to mars is a drop and down list
with all items and in it includes mars too i want to find a way to
change that cell to display mars automatically when some other cell
reaches 3000...

Thanks for your time
From John Wood


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=501876