| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation - e-mail
Worked perfectly!!
Thanks so much T "JP" wrote: Here is one way. 1. Click FormatConditional Formatting on the menu bar 2. Choose "Formula Is" and paste this in the formula box: =SEARCH("@",A1,1)0 3. Click "Pattern" and choose whatever color you want This simply does an unintelligent search of A1 to see if contains the "@" character. You could also use this in the DataValidation box for the same effect. HTH, JP On Jan 17, 12:23 pm, Theo wrote: I want to be sure that the entry into a cell is an email address - is there a way to ensure that at least one character (any character) is an at sign (@). Any ideas appreciated!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| E-Mail attachment to same e-mail address in Outlook | Excel Discussion (Misc queries) | |||
| Validation on E-mail address | Excel Worksheet Functions | |||
| E-mail macro - Field Validation | Excel Discussion (Misc queries) | |||
| Error: cannot load the mail service. Check your mail installation. | Excel Discussion (Misc queries) | |||
| General mail failure when sending e-mail from Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
