How to add conditional formatting to Google Sheets drop-down list

When you want better visualizations of your Google Sheets data, conditional formatting is the way to go.
http://dlvr.it/SlHCLl