+ Reply to Thread
Results 1 to 2 of 2

If Cell A contains Value Cell B must be enter.

  1. #1
    Registered User
    Join Date
    12-29-2015
    Location
    Bahrain
    MS-Off Ver
    2013
    Posts
    1

    If Cell A contains Value Cell B must be enter.

    Hi

    I have an excel sheet where I want to bound the user if the cell A1 have an specific value than B1 must not be blank. B! should have the value.

    E.g.
    If cell A1 have "Xy" or "YZ" user must enter the value in cell B1.
    if there is any other value user can leave the cell blank.


    Please help

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: If Cell A contains Value Cell B must be enter.

    Are the A1 values fixed or variable ?
    Elegant Simplicity............. Not Always

+ 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] Enter number in blank cell match number on sheet 2 & enter data from adjacent cell
    By Bikeman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-10-2015, 08:36 PM
  2. Replies: 5
    Last Post: 06-01-2015, 03:38 PM
  3. [SOLVED] If month in cell A is equal to number in cell B then enter cell C
    By badincite in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 05-02-2015, 12:27 PM
  4. [SOLVED] How do I create a button to enter a number in a cell and then tab/enter to next cell
    By MatiasGarcia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2013, 05:29 PM
  5. [SOLVED] Return alt-enter when enter is pressed in a specific cell
    By bigsteve in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2013, 10:21 AM
  6. Hit enter in cell & move text down in cell, not go to cell below.
    By raoul_duke in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  7. [SOLVED] Hit enter in cell & move text down in cell, not go to cell below.
    By raoul_duke in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-26-2005, 02:05 PM

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