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

Channel:
United States Google Workspace
Subscribers:
1,010,000
Published on ● Video Link: https://www.youtube.com/watch?v=Ezt-Ul0xb9M


Category:
Guide
Duration: 1:47
70,591 views
579

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

#GoogleWorkspaceProTips #CustomizingGoogleWorkspace



Other Videos By Google Workspace


2018-12-21What's New for G Suite Admins? - November 2018 Edition
2018-12-18How to automatically add a schedule from Google Sheets into Calendar
2018-12-11Intuit transforms their workplace with Box for G Suite
2018-11-28What's New for G Suite Admins? - October 2018
2018-11-05Advanced Protections: Eliminating Malware, Phishing, Spam in G Suite (Next Rewind '18)
2018-10-22Google Domains - You know
2018-10-22Google Domains — Nailed it
2018-10-22Google Domains - Easy
2018-10-22Google Domains - All this
2018-10-19What's New for G Suite Admins? - September 2018 Edition
2018-10-17How to create dropdown lists and use conditional formatting in Google Sheets
2018-10-1630 Ways Google Sheets Can Help Your Company Uncover and Share Data Insights (Next Rewind '18)
2018-10-04@suaempresa com G Suite
2018-10-04Drive do G Suite
2018-10-04Colabore com o G Suite
2018-10-04Colabore com o G Suite
2018-09-24What's New for G Suite Admins - August 2018 Edition
2018-09-13G Suite’s Google Drive: A safe place for all your work files
2018-09-13G Suite’s Google Drive: A safe place for all your work files
2018-09-13Google Drive: An Intuitive Partner for Content Services (Next Rewind '18)
2018-09-10What's New for G Suite Admins - January 2018 Edition


Tags:
How to create dropdown lists and use conditional formatting in Google Sheets
conditional formatting
data validation
matrix
trix
matrices
Google Spreadsheet
how to add dropdown list
organization
organizing spreadsheet
list of names
format
rules
color coding
spreadsheet tips and tricks
G Suite
Pro Tips
Joanna Smith
GDS: Yes;