+ Reply to Thread
Results 1 to 2 of 2

Entry based on entry of another cell

  1. 11-20-2014, 04:03 PM #1
    mikerules
    mikerules is offline
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    221

    Entry based on entry of another cell

    I would like A2 to be blank only if A1 = Multi Quote otherwise I want the formula in A2 to populate the cell. An option would be to use Conditional Formatting to make the font white and not visible if A1 = Multi Quote if this is possible to do?
    Reply With QuoteRegister To Reply
  2. 11-20-2014, 04:11 PM #2
    Melvinrobb
    Melvinrobb is offline
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Entry based on entry of another cell

    just enter the formula you want in A2 into the formula below:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Please click the * icon below if I have helped.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Validate that entry in one cell matches an entry in another range of cells
    By Grilleman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-01-2014, 03:57 PM
  2. [SOLVED] Need an entry in one cell to cause an entry in another based on entry in 3rd
    By mikerules in forum Excel General
    Replies: 4
    Last Post: 03-21-2014, 12:01 AM
  3. Allow entry based on another cell
    By Kate0408 in forum Excel General
    Replies: 4
    Last Post: 08-16-2011, 11:36 PM
  4. Preventing entry to a specific cell once another cell have already an entry from list
    By jas_tolentino in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-06-2011, 08:25 PM
  5. How do I prevent data entry in one cell if an entry exist in another cell
    By rkjudy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-13-2010, 09:38 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1