| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
