From the course: Office for Educators
Unlock this course with a free trial
Join today to access over 22,400 courses taught by industry experts.
Solution: Write a conditional format - Microsoft Office Tutorial
From the course: Office for Educators
Solution: Write a conditional format
For this challenge, I'm first going to focus on writing conditional formatting for a single cell and then apply the conditional formatting to the entire section of the grade book that I'd like it to be applied to. Here we have cell F4. I can see that the cell F4 is indeed greater than the total point of this assignment, which is 12. So, I'm going to go and select Cell F4. Under the home section of the ribbon, I'm going to go and click on Conditional Formatting. The first thing I'd like to do is to write the formula that'll highlight this cell, because its value is greater than the total points possible for the assignment. To do that, I'm going to select Highlight Cell Rules and I'm going to click on More Rules. Here, I'm going to choose to use a formula to determine which cell to format. The formula for this is fairly straightforward. It's going to be equal to, parenthesis, F4 is greater than F2, and a closing parenthesis. Let's click on Format. We're going to go to Fill, and we're…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
Creating a gradebook1m 3s
-
Understanding cells2m 50s
-
Creating the gradebook layout3m 29s
-
Creating a dropdown list of assignment types3m 36s
-
Writing the grade calculation functions5m 44s
-
Using conditional formats5m 45s
-
Setting the print area3m 17s
-
Adding headers and footers2m 28s
-
Adding list sorting2m 38s
-
Freezing frames and cleaning up2m 43s
-
Replicating sheets2m
-
Challenge: Write a conditional format58s
-
Solution: Write a conditional format4m 20s
-
-
-
-
-
-
-
-
-