Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-23-2019, 04:15 AM
UJ18 UJ18 is offline Conditional Formatting to activate Multiple Choices After Chosen From The Drop Down List Windows 7 64bit Conditional Formatting to activate Multiple Choices After Chosen From The Drop Down List Office 2013
Novice
Conditional Formatting to activate Multiple Choices After Chosen From The Drop Down List
 
Join Date: Dec 2019
Posts: 2
UJ18 is on a distinguished road
Exclamation Conditional Formatting to activate Multiple Choices After Chosen From The Drop Down List

Hi All,



Sorry if there's any confusion.

I will like to use conditional formatting to resolve the following issues.

I have 2 tiers of shows' genres.

After choosing Tier 1 from the the drop-down list, I should be able to choose the following choices under the tier 2 (list box) which ever are link under tier 1.

TiersGenres.jpg

I am not too sure what is the correct way to do this, can someone please advise, thanks.

Last edited by UJ18; 12-23-2019 at 01:06 PM.
Reply With Quote
  #2  
Old 12-23-2019, 12:54 PM
macropod's Avatar
macropod macropod is online now Conditional Formatting to activate Multiple Choices After Chosen From The Drop Down List Windows 7 64bit Conditional Formatting to activate Multiple Choices After Chosen From The Drop Down List Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your image doesn't display correctly, apparently because it's a link to a 3rd-party website whose content doesn't display correctly here. Instead of trying to link to a 3rd-party website, upload the actual image here - via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

That said, see:
Change color according with dropdown selection
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-23-2019, 10:58 PM
UJ18 UJ18 is offline Conditional Formatting to activate Multiple Choices After Chosen From The Drop Down List Windows 7 64bit Conditional Formatting to activate Multiple Choices After Chosen From The Drop Down List Office 2013
Novice
Conditional Formatting to activate Multiple Choices After Chosen From The Drop Down List
 
Join Date: Dec 2019
Posts: 2
UJ18 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Your image doesn't display correctly, apparently because it's a link to a 3rd-party website whose content doesn't display correctly here. Instead of trying to link to a 3rd-party website, upload the actual image here - via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

That said, see:
Change color according with dropdown selection
Hi, but does it work for different row/column? Tier 1 supposed to be row 1 and Tier 2 supposed to be row 2; row 2 should appeared after tier 1's category been chosen.
Reply With Quote
  #4  
Old 12-25-2019, 03:57 AM
Guessed's Avatar
Guessed Guessed is offline Conditional Formatting to activate Multiple Choices After Chosen From The Drop Down List Windows 10 Conditional Formatting to activate Multiple Choices After Chosen From The Drop Down List Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I think your terminology is wrong. It sounds like you are more interested in finding out about cascading (or dependent or hierarchical) content controls. Try macropod's links in this thread https://www.msofficeforums.com/word/...drop-down.html
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 01-01-2020, 01:59 AM
macropod's Avatar
macropod macropod is online now Conditional Formatting to activate Multiple Choices After Chosen From The Drop Down List Windows 7 64bit Conditional Formatting to activate Multiple Choices After Chosen From The Drop Down List Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

For:

1. Dependent Dropdown Content Controls, see:
Help with cascading dropdown list

2. Hierarchical Dropdown Content Controls, see:
Creating a reducing drop down list
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a document which drop-down list cascade to further set choices sfieldes Word 1 01-08-2019 09:39 PM
Using a Drop Down list to populate a cell with multiple choices, Word 2010 Barehands Word VBA 3 04-04-2018 05:11 AM
Conditional Formatting Drop-Down List (WORD 2013) rogelinepaula Word VBA 1 10-15-2015 05:18 AM
Create a fillable form that changes a paragraph depending on what is chosen in a drop down list. Sullivanaudio Word VBA 1 03-31-2015 10:45 PM
Drop down lisr with multiple choices Richard121 Excel 1 02-17-2015 08:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:47 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft