Answered step by step
Verified Expert Solution
Question
1 Approved Answer
As a teacher, you keep a spreadsheet of your students and all their grades. You want to highlight the cells of those who passed the
As a teacher, you keep a spreadsheet of your students and all their grades. You want to highlight the cells of those who passed the mark with green, and those who failed with red. How will you best go about this?
Highlight the specific range of cells and click on the button for conditional formatting. Input a formula to check if the data passes and format it with a green background. Add another rule for those below to red.
Highlight a specific range, right click and click on Formatting Type the passing score when prompted and choose the colors for the passing data and failed data.
Apply a formula to each individual cell where if it goes over the passing mark, it displays "Passed" or "Failed". Then go over the table and change the background of the cells with "Passed" to green and those with "Failed" to red.
Check each value of the final grade. For those at or above, change the background of the cell to green. For the rest, change the background to red.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started