In the Allow list, choose Custom and use a formula like

=$A$1="a"

This will allow you to enter a value in A2 if A1 is either "A" or "a". For
an exact case match, use

=EXACT($A$1,"a")

will allow entry if A1 is "a" but not if A1 is "A".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Darin Kramer" wrote in message
...


Hi there,

Im looking to create some data validation in say cell a2, that says if
cell a1 = "a", then allow a2 to accept a number, if a1 = anything else
then dont allow entry into a2.
Is it possible using custom data validation...? I cant seem to get any
sensical result from using custom...

Regards

Darin

*** Sent via Developersdex http://www.developersdex.com ***