+ Reply to Thread
Results 1 to 6 of 6

Locking cell when date is before 01.01.2011

  1. #1
    Registered User
    Join Date
    02-05-2012
    Location
    Birmingham, England
    MS-Off Ver
    2007
    Posts
    3

    Locking cell when date is before 01.01.2011

    Hello,
    Any chance someone can help me with the formula. If for example in cell A1 is date that is equal or before 01.01.2011 i need to lock cell B1 so it would be impossible to input data in cell B1.
    Thanks

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Locking cell when date is before 01.01.2011

    Hello
    Using data validation with this custom formula placed in B1.

    =$A$1>DATE(2011,1,1)

    Hope this helps.

  3. #3
    Registered User
    Join Date
    02-05-2012
    Location
    Birmingham, England
    MS-Off Ver
    2007
    Posts
    3

    Re: Locking cell when date is before 01.01.2011

    Hello,
    Thanks formquick reply but this onlt gives me True/False in b1

  4. #4
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Locking cell when date is before 01.01.2011

    Hi
    You need to select B1, go to Data Validation on the Ribbon. Settings tab, then in Allow drop down, select Custom and in Formula place the formula I described. You may add any messages you like here also. When you try to place a value in B1 and the date is less than or equal to 1/1/11 in A1, it should block any entry.

  5. #5
    Registered User
    Join Date
    02-05-2012
    Location
    Birmingham, England
    MS-Off Ver
    2007
    Posts
    3

    Re: Locking cell when date is before 01.01.2011

    H-U-G-E Thanks for your help.

  6. #6
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Locking cell when date is before 01.01.2011

    You're welcome , I should have made it clearer in my first reply.
    Regards DBY

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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