+ Reply to Thread
Results 1 to 5 of 5

Formula combined with drop down list (previously wrong forum)

  1. #1
    Registered User
    Join Date
    11-10-2005
    Location
    Scotland
    Posts
    69

    Formula combined with drop down list (previously wrong forum)

    Hi
    This one has me stumped.
    I have attached a sample of the spreadsheet to help clarify what Im after.
    If cell B11 ='CASH' then cell C11 will turn green (conditional format), but I would like the value to change to a 'YES' (but I still want to have the option of the drop down list)
    The problem is, I still want the cell to operate as a drop down list, and so if you change the value of cell B11 later, you have the option to change the value of C11 via the drop down list.
    To explain the principle of what I am doing, the spreadsheet is a personal track of monthly receipts which are then checked against bank statements.
    When you enter a receipt amount, you also specify which card was used to make the purchase. (B11)
    Once the bank statement comes in, then C11 (which starts off as a red fill with an X symbol) can be changed to YES to show that the receipt has been checked off against the bank statement.
    If however when you enter the receipt and it is CASH in B11, then C11 should automatically change to green (which it currently does), but also to YES as any cash transactions wont need to be checked against a bank statement.
    Also, it would be neater if C11 remained blank until B10 had a value in it. Once B10 has a value in it, C11 would change to the X with the red fill.
    I hope this makes some sense

    Thank you in advance

    Craig
    Attached Files Attached Files

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Formula combined with drop down list (previously wrong forum)

    This is a duplicate post . If you think you had the wrong forum initially, then provide a link to that thread to prove it and to show that you were told it would require VBA.
    Last edited by NBVC; 01-28-2010 at 08:52 AM.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Formula combined with drop down list (previously wrong forum)

    I responded to the initial question here: Data validation with formulas

    The OP did not have the courtesy of replying or offering thanks for help given. I'm not inclined to provide further assistance.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Formula combined with drop down list (previously wrong forum)

    Craig, in light of Palmetto's post, I think it is fair to re-instate the duplicate post infraction.... Please do not post duplicates... especially when someone was kind enough to supply a solution... If the solution was not what you were looking for, then you need to say that in the same post and I am sure the responder or others will make an effort to help come to a solution that works for you.

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules.
    Last edited by NBVC; 01-28-2010 at 10:42 AM.

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Formula combined with drop down list (previously wrong forum)

    I've moved the original to programming.

    Thanks Palmetto,maybe the OP will remember his manners
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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