Assign Student$\_$Grades as Range Name for B$3$:B$11.$

$3.$ Apply Conditional Formatting to B$3$:B$11$ where all scores lower than $80$ are highlighted in

BOLD RED font and display Failed: in front of these scores. Also, format the numbers to

show $2$ decimal places.

$4.$ Apply Conditional Formatting, using a formula, to A$3$:A$11$ to highlight the Student name in

BOLD with RED font if the student$$s score $($in B$3$:B$11)$ is lower than $80.$

$5.$ You must not write Failed: into the cells. Your result should look like this: