Sheets: Conditional Formatting
Learning Activity
Conditional formatting color codes cells based on the data they contain. Set rules to identify which cells you'd like to highlight; multiple rules can be used and on any selection of cells/columns/rows. This feature is useful for sorting out assignments that are late or under the pass mark; identifying absence trends; categorizing responses to a survey. Create a spreadsheet or use an existing spreadsheet. Apply the following conditional formatting rules:
- If a cell is empty
- If a cell is not empty
- Value is less than
- Date is after
Resources
More Sheets Activities
Quickly deploy Sheets lessons to your entire district.
Top districts trust Alludo to train teachers and staff
![Oakland Unified School District](https://cdn-alludo.alludolearning.com/district/logo/259/logo-1646921824.png)
![Little Rock School District](https://cdn-alludo.alludolearning.com/district/logo/268/logo-1652837094.png)
![Oxnard Union HSD](https://cdn-alludo.alludolearning.com/district/logo/31/logo-1601655173.png)
![Santa Ynez Valley Union HS](https://cdn-alludo.alludolearning.com/district/logo/270/logo-1657058767.png)
![Georgia Department of Education](https://cdn-alludo.alludolearning.com/district/logo/267/logo-1652473693.png)