Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Data Validation
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Data Validation
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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Data Validation
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
Data Validation, Custom | Excel Worksheet Functions | |||
Custom Data Validation | Excel Discussion (Misc queries) | |||
custom data validation | Excel Discussion (Misc queries) | |||
Custom data validation | Excel Discussion (Misc queries) |