Embedded Files
The Basics of Conditional Formatting
The Basics of Conditional Formatting
I need help!
I need help!
Not quite sure you'll remember everything we showed you about conditional formatting during our Digital Learning Day YouTube Live Session? Below are some helpful resources to guide you along the way.
Conditional Formatting.mp4How to use conditional formatting rules in Google Sheets
How to use conditional formatting rules in Google Sheets
- Click here for directions on how to change cells, rows, or columns text or background color if they meet certain conditions. (For example: they contain a certain word or a number.)
Color by Number with GSheets.mp4Use advanced conditional formatting
Use advanced conditional formatting
- Want to use a custom formula to drive your conditional formatting? Click here for directions and scroll down the page. Learn how to use specific formulas to apply conditional formatting to cell(s) based on the contents of other cells on the same spreadsheet or other spreadsheets in the same workbook.
- Are you interested in creating a "wildcard" rule to your cells? Click here for directions and scroll down the page. Learn how to apply conditional formatting for multiple expressions.
Conditional Formatting for Grade Data.mp4Take it up a notch
Take it up a notch
- Learn how to format cells in Google Sheets by multiple condition by following these directions. This is what you'll need to do if you choose to use conditional formatting to evaluate data from an assessment.
- (Example: Color grades 80+ green, color grades 60-79 yellow, and color grades 59- red)
- You can learn how to format cells based on another cell text by following these directions. This is how we created our Color by Number template.
Image Source: All images on this site are registered as Public Domain.
Report abuse