Formula combined with drop down list (previously wrong forum)

[craigproudfoot]

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

[NBVC]

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.

[Palmetto]

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.

[NBVC]

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.

[royUK]

I've moved the original to programming.

Thanks Palmetto,maybe the OP will remember his manners