+ Reply to Thread
Results 1 to 3 of 3

Cell formatting based on seperate cell

  1. #1
    Registered User
    Join Date
    07-02-2016
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    5

    Cell formatting based on seperate cell

    I'm creating an excel calculator and i need the user to select inputs from a number of fields before the calculation is run. Depending on what the user selects i need secondary cells to display different options. In this case:

    I have a cell with a dropdown which is either Yes or No.
    If the user selects "Yes" in cell A1 then i want cell B1 to have a dropdown for "Plan 1" and "Plan 2" available.
    If the user selects "No" from cell A1 dropdown i'd like cell B2 to be un-editable, or failing that, display something like "N/A"

    Is that possible?

    Thanks,
    Jack

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Cell formatting based on seperate cell

    I assume that if A1 is empty you'd also like to restrict the value of B1?

    Enter Plan 1 and Plan 2 is some cells. Assume that's A10:A11.

    Setup the drop down list in cell B1. As the source for the list use this formula:

    =IF(OR(A1="No",A1=""),#N/A,A10:A11)

    If you get a message that says: The source currently evaluates to an error...

    Just answer: Yes
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Perth Western Australia
    MS-Off Ver
    Office 365
    Posts
    257

    Re: Cell formatting based on seperate cell

    Hi

    The following You Tub will provide some answers

    https://www.youtube.com/watch?v=Gm5m-y49rI0

    Cheers

+ 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] How to use Conditonal Formatting to highlight seperate cell?
    By R1_Canuck in forum Excel General
    Replies: 4
    Last Post: 03-10-2016, 06:07 AM
  2. Based on text in cell, put number value in seperate cell
    By Tailoredcs in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-10-2013, 01:44 PM
  3. [SOLVED] Adding Or Subtracting Cells Based On A Date Within A Seperate Cell
    By Gtrtim112 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-09-2013, 03:09 PM
  4. Replies: 2
    Last Post: 10-14-2012, 06:53 AM
  5. [SOLVED] Populate a Cell with text based on the result of 2 seperate formulas
    By Medwards73 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2012, 08:56 AM
  6. [SOLVED] Sum X amount of cells in a row based on a seperate cell but ignoring blanks
    By How How in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-31-2012, 09:24 AM
  7. Lookup value on seperate sheet based upon cell value
    By phantasm in forum Excel General
    Replies: 4
    Last Post: 05-09-2011, 04:50 PM

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