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.