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

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…

Contents