You can use data validation if the entry is being typed into U35, but if
U35 is a formula, that won't do it..

---Glenn


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=523300