How to create dropdown lists and use conditional formatting in Google Sheets

G Suite Pro Tips are quick tutorial videos to help you automate simple tasks at work. In this video, a G Suite Developer Advocate explains how to nail your spreadsheet organization using two key features in Google Sheets: Data Validation and Conditional Formatting. Use these features to add dropdown lists to cells or color-code tasks. For a step-by-step guide, click here: http://bit.ly/2J3WlgA If you have additional questions or ideas for future G Suite Pro Tips, leave them in the comments below! Also, remember to subscribe for more tips and latest updates → http://bit.ly/G-Suite1 https://ift.tt/2NKDcRK G Suite October 17, 2018 at 12:15PM