Excel: Conditional Formatting

145 Learners | 145 Completed Lessons | 36 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 cell is empty
  2. If cell is not empty
  3. Value is less than
  4. Date is after

Resources

More Excel Activities

Quickly deploy Excel lessons to your entire district.

Points 25 | Time 00:10

Points 50 | Time 00:20

Points 25 | Time 00:15

Points 50 | Time 00:30

Points 50 | Time 00:20

Points 25 | Time 00:15

Points 50 | Time 00:25

Points 75 | Time 00:45

Points 25 | Time 00:20

Top districts trust Alludo to train teachers and staff

Palm Springs Unified Georgia Department of Education Colton Joint Unified SD Little Rock School District Newport-Mesa Unified School District