Allow (validation) except

M

mfebinger

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.
 
D

Debra Dalgleish

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 Data>Validation
From the Allow dropdown, choose Custom
In the Formula box, type the formula:

=COUNTIF($A$1:$A$10,D3)=0

Click OK
 
Top