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 *** |
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 *** |
Custom Data Validation
|
All times are GMT +1. The time now is 07:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com