+ Reply to Thread
Results 1 to 5 of 5

ISBLANK in 3 Rows Conditional DATA Validation EASY

Hybrid View

  1. #1
    Registered User
    Join Date
    01-11-2012
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    3

    ISBLANK in 3 Rows Conditional DATA Validation EASY

    Here is a simple problem... it should be a no-brainer but I just can't get it to work.

    I have column A, B and C. I want Data to be entered in A only when B and C are blank. Same with each column. Data can only be entered in B when A and C are blank and so on... (so that Data can only be entered in one Column at a time)

    I use Data Validation : Custom

    Formula =ISBLANK(B1:C1)

    as such it works, but when I perform the same operation for columns B and C, then I can never enter Data without getting my custom error msg, even if the two other cells (B1 and C1) are blank


    More details: basically this would be for budgets and some amounts can be put in weekly, monthly and yearly... but two timeframes cannot be used for one item.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,047

    Re: ISBLANK in 3 Rows Conditional DATA Validation EASY

    Hi and welcome to the forum

    TRy this, and adjust as needed....

    =COUNTA(B1,C1)=0
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

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

    Re: ISBLANK in 3 Rows Conditional DATA Validation EASY

    FDibbins' suggestion works

    Alternatively, 1 consistent data validation rule across all 3 cells

    =COUNTA($A1:$C1)=1
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Registered User
    Join Date
    01-11-2012
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: ISBLANK in 3 Rows Conditional DATA Validation EASY

    You guys are awesome thanks!!!! I'll try that second one tomorrow....

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,047

    Re: ISBLANK in 3 Rows Conditional DATA Validation EASY

    Nice 1 Ace, + for you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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