Custom Data Validation

[Darin Kramer]

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

 

[Chip Pearson]

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]

Thanks!!!


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