Sheets: Conditional Formatting

470 Learners | 477 Completed Lessons | 239 Hours of Learning Time

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:

  1. If a cell is empty
  2. If a cell is not empty
  3. Value is less than
  4. Date is after



Resources

More Sheets Activities

Quickly deploy Sheets lessons to your entire district.

Points 25 | Time 00:10

Points 25 | Time 00:15

Points 50 | Time 00:30

Points 50 | Time 00:20

Points 25 | Time 00:15

Points 50 | Time 00:20

Points 50 | Time 00:30

Points 75 | Time 00:45

Top districts trust Alludo to train teachers and staff

Lake Worth ISD Lancaster School District Berryessa Union School District Alum Rock Union School District Santa Ynez Valley Union HS