Conditional Formatting in Google Sheets allows users to change cell font and background properties based on the values in the cells themselves. Jess Stratton takes you through several examples of how and why you would want to do this.
- [Instructor] Conditional formatting allows you to change…the format of certain cells based on condition,…such as the value in the cell itself.…You can change the font properties of a certain cell,…row, or column,…even the color of the cell itself.…This is useful for being able to quickly glance at a sheet…to see patterns of data,…trouble spots, good news,…or even a faulty or a flawed data.…This last column contains the last time…a hotel guest stayed with us at the Landon Hotel.…I wanna be able to glance at the sheet…and quickly spot which guests haven't stayed with us…in quite a while.…
We can do that with Conditional formatting.…I'll get started by clicking the H column header…to select the entire column.…Now I'll click Format at the top of the screen…and choose Conditional formatting.…It's going to open up the Conditional formatting pane…on the right hand side.…I need to check and make sure…that the correct range is being applied to,…in this case it's the entire column of H,…and here I can click the two up and down arrows…
- Explain why it is beneficial to use a template spreadsheet in Google Sheets rather than start from scratch.
- Name the action you would need to take to make data fit in a column on a Google sheet.
- List the steps to include multiple lines in a cell.
- Explain how to use the iframe code for a chart when publishing it to a website.
- Recall the main advantage of using IFTTT services with Google Sheets.
- Recognize situations where Google Sheets email notifications would be useful.