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 ***

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
>
> 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 ***

Thanks!!!


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