Results 1 to 8 of 8

Override cell value with conditional format

Threaded View

craigproudfoot Override cell value with... 01-25-2010, 03:18 PM
shg Re: Override cell value with... 01-25-2010, 03:26 PM
teelim Re: Override cell value with... 01-26-2010, 05:01 AM
craigproudfoot Re: Override cell value with... 01-26-2010, 02:52 PM
teelim Re: Override cell value with... 01-27-2010, 12:08 AM
craigproudfoot Re: Override cell value with... 01-27-2010, 12:00 PM
craigproudfoot Re: Override cell value with... 01-28-2010, 08:25 AM
NBVC Re: Override cell value with... 01-28-2010, 08:56 AM
  1. #1
    Registered User
    Join Date
    11-10-2005
    Location
    Scotland
    Posts
    69

    Override cell value with conditional format

    Hi
    This one has me stumped.
    I have attached a sample of the spreadsheet to help clarify what I’m 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 won’t 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

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