| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stumped Conditional Formatting or Validation?
I have searched Contextures.com, Excel help online, and this community and I
am baffled (been staring at this too long). I know the answer is simple, it just escapes me. Excel 2007- I have cell D11 and D12 I want a dropdown of Yes,No; only one cell can have a Yes answer. Then if D11 is Yes, move user to cell E15, if D12 is Yes, move user to cell E13. I thought I could do a Data Validation using Custom/Formula. I appreciate your help. Thank you! -- Thank you, scrowley(AT)littleonline.com |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Stumped Conditional Formatting or Validation?
Nothing can move the users to another cell other than a VBA macro
If you are ready for this; post your Q in the programming newsgroup best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "SCrowley" wrote in message ... I have searched Contextures.com, Excel help online, and this community and I am baffled (been staring at this too long). I know the answer is simple, it just escapes me. Excel 2007- I have cell D11 and D12 I want a dropdown of Yes,No; only one cell can have a Yes answer. Then if D11 is Yes, move user to cell E15, if D12 is Yes, move user to cell E13. I thought I could do a Data Validation using Custom/Formula. I appreciate your help. Thank you! -- Thank you, scrowley(AT)littleonline.com |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Stumped Conditional Formatting or Validation?
Thank you, Bernard.
What if just cell D11 and D12 have a dropdown of Yes,No; only one cell can have a Yes answer? -- Thank you, scrowley(AT)littleonline.com "Bernard Liengme" wrote: Nothing can move the users to another cell other than a VBA macro If you are ready for this; post your Q in the programming newsgroup best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "SCrowley" wrote in message ... I have searched Contextures.com, Excel help online, and this community and I am baffled (been staring at this too long). I know the answer is simple, it just escapes me. Excel 2007- I have cell D11 and D12 I want a dropdown of Yes,No; only one cell can have a Yes answer. Then if D11 is Yes, move user to cell E15, if D12 is Yes, move user to cell E13. I thought I could do a Data Validation using Custom/Formula. I appreciate your help. Thank you! -- Thank you, scrowley(AT)littleonline.com |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Stumped Conditional Formatting or Validation?
One way:
Put the dropdown in D11 only. In D12 enter =IF(D11="Yes","No","Yes") In article , SCrowley wrote: What if just cell D11 and D12 have a dropdown of Yes,No; only one cell can have a Yes answer? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Stumped Conditional Formatting or Validation?
So simple and exactly what I need. Thank you, JE McGimpsey!
-- Thank you, scrowley(AT)littleonline.com "JE McGimpsey" wrote: One way: Put the dropdown in D11 only. In D12 enter =IF(D11="Yes","No","Yes") In article , SCrowley wrote: What if just cell D11 and D12 have a dropdown of Yes,No; only one cell can have a Yes answer? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - Dependent Lists & Conditional Formatting | Excel Worksheet Functions | |||
| Finding data validation and conditional formatting | Excel Discussion (Misc queries) | |||
| Data Validation & Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
| Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Linear Mode
