+ Reply to Thread
Results 1 to 2 of 2

Validation for non-blank entry and upper case values

  1. #1
    Registered User
    Join Date
    Hammonton, NJ USA
    MS-Off Ver

    Validation for non-blank entry and upper case values

    Column E is the issue here.
    1. If any of Cols A-D have an entry, force an entry in Col E.
    2. Col E has validation for I or F, but Excel is permitting lower case i or f as well.
    3. Col F and G are working OK.

    Thanks for helping.
    Attached Files Attached Files
    Last edited by gdstuart; 05-21-2020 at 05:39 PM. Reason: Prompt and creative assistance! I really appreciate the help.

  2. #2
    Forum Guru
    Join Date
    MS-Off Ver

    Re: Validation for non-blank entry and upper case values

    Forcing an entry into G
    Excel can't force an entry into G except through VBA. IF you want them to make the entry into G before entering anything in A:D, that's possible with Data Validation but not the other way around. You could also use Conditional formatting to make the whole row Red until G is filled in (if there's something in A:D)

    Capital I or F in E
    You can go to Custom Data Validation and use this formula =OR(EXACT(E5,"F"), EXACT(E5,"I")) but you will lose your dropdown menu. Again, the way around that would be with VBA if you want.
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ 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. [SOLVED] Find and replace Lower case values with upper case values
    By Gssoc777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-20-2016, 12:52 PM
  2. Replies: 7
    Last Post: 09-21-2015, 01:58 PM
  3. Segmenting strings based on capitalization (upper case) values
    By beckdog in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2014, 12:44 PM
  4. Upper case only, in data validation?
    By proepert in forum Excel General
    Replies: 2
    Last Post: 12-08-2010, 11:37 PM
  5. Conditional Formatting Duplicate Values (Upper & Lower Case)
    By Orangeworker in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-05-2010, 04:01 AM
  6. [SOLVED] Changing file in all upper case to upper and lower case
    By Sagit in forum Excel General
    Replies: 14
    Last Post: 08-25-2005, 10:05 PM
  7. Replies: 1
    Last Post: 03-09-2005, 05:06 PM

Tags for this Thread


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