How to add conditional formatting to a Google Sheets drop-down list (and why you should)

Adding conditional formatting to a Google Sheets drop-down list helps automate the formatting of your spreadsheet cells.