+ Reply to Thread
Results 1 to 3 of 3

data validation - or function for text

  1. #1
    Forum Contributor
    Join Date
    05-08-2005
    Location
    Australia
    MS-Off Ver
    excel 2019
    Posts
    112

    data validation - or function for text

    Sorry I know it will be simple

    want a1 to have text of either "andrew" or "trudy" what is the formula for this? I don't want a drop down menu just a formula and alert if it is not either of these

    regards

    andrewm

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: data validation - or function for text

    You can use data validation that permits only one of there names, not a drop down list, but ... you question has no logic, maybe you should explain a why so it makes more sense.
    If it's the acutal username, that just fille that cell with the active username when the file opens.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: data validation - or function for text

    U
    se conditional formatting for Cell A1 as an alert

    =AND($A$1<>"andrew",$A$1<>"trudy")

    Format as Red

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Function of function of cell reference in data validation.
    By Borkar2018 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2018, 04:27 AM
  2. [SOLVED] Typing partial text to result in full text in data validation drop down box
    By jennis7242 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-18-2018, 09:39 PM
  3. Replies: 0
    Last Post: 10-03-2013, 02:02 AM
  4. Data Validation and IF function
    By Edexcel386 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-11-2011, 10:37 AM
  5. IF Function & Data Validation
    By oceans11 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2011, 11:51 PM
  6. Function in data validation that keeps user from entering duplicate data?
    By comptechbranden in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-26-2007, 05:31 AM
  7. Data Validation Function Help
    By John Jost in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-22-2005, 11:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1