List the "do not quote" account numbers on a worksheet. In this example
they're in cells A1:A10
Select the cell in which you want data validation
(cell D3 in this example)
Choose DataValidation
From the Allow dropdown, choose Custom
In the Formula box, type the formula:
=COUNTIF($A$1:$A$10,D3)=0
Click OK
mfebinger wrote:
Hey, all. I want to allow all users to enter account numbers into an excel
log, except for "do not quote" account numbers, but I can't figure out how to
do it. Is there a way to allow anything except a few account numbers.
Thanks.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html