Hi,
First of all, you can't use Data Validation after the data is entered. You may
apply the validation, but it won't react to invalid data. It only responds to
data entered after the validation rule is in place. If you want to be alerted
to invalid data that is already present, you'd probably have to write a macro.
But for normal Data Validation:
If you want to exclude data with the letter 'X' you can use:
=ISERROR(SEARCH("X",A1))
If you want it to be case sensitive, use the FIND function instead:
=ISERROR(FIND("X",A1))
If you want to allow only data with 'X', then use:
=SEARCH("X",A1)
or
=FIND("X",A1)
I've used cell A1. Change this for whatever cell you are using.
Hope this helps.
Regards - Dave.
> Date: Thu, 26 Aug 2010 12:52:42 -0700
> Subject: $$Excel-Macros$$ Validation rule and 'X'
> From: janes...@gmail.com
> To: excel-macros@googlegroups.com
>
> I have a list of products containing combinations of letters and
> numbers. I want to create a validation rule under 'Custom' which runs
> when a product containing the letter X is typed. how would I express
> this in the formula? Thanks in advance.
> Hane
>
> --
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
