+ Reply to Thread
Results 1 to 4 of 4

Custom Data Validation

  1. #1
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    Custom Data Validation

    I have 3 cell : f2 ,g2 and h2

    I want to input ONLY ONE of this 3 cells.(Only One is permited , but other two cells to be locked to input)
    Example: If G2 and/or H2 is filled with numbers, F2 must be prevented to input a number.
    Same condition is valid for G2 and H2 cells.

    How can it be solved with Custom Data Validation ( or simple macro)

    F2, G2, H2 cells going down to 4000th rows with same condition.

    Thanks in advance for any reply and help.

    Regards,
    turist

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: Custom Data Validation

    If I understand well, maybe with this custom data validation :

    Select F2:H2 and add this custom data validation : =COUNTA($F2:$H2)=1
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,461

    Re: Custom Data Validation

    In row 2, set up the following Data Validation, Custom, rule in F2:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Then copy that cell to the right to columns G and H.

    Then copy down for 4000 rows.
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    Re: Custom Data Validation

    Thank you all and rep.

+ 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. Custom data validation
    By superboy in forum Excel General
    Replies: 0
    Last Post: 01-20-2014, 12:05 PM
  2. Custom Data Validation
    By Grilleman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-25-2012, 11:52 AM
  3. custom data validation
    By sameer.sheik in forum Excel General
    Replies: 2
    Last Post: 02-09-2012, 01:51 PM
  4. Custom data validation??
    By turbofatty in forum Excel General
    Replies: 3
    Last Post: 08-02-2011, 10:24 AM
  5. Custom data validation
    By Guy Normandeau in forum Excel General
    Replies: 3
    Last Post: 04-18-2006, 11:15 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