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…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Protecting sheets against unwanted changes
- Rearranging rows and columns
- Adding data validation to cells
- Using the image function to easily add images to cells
- Inserting a gauge chart for status updates
- Adding estimate data to Google charts
- Publishing charts to a website
- Using Google Forms to create surveys
- Using Google Sheets add-ons