Question

Use conditional formatting to find whether each student has passed or failed in the exam

Answer 1

Answer:

Use Conditional Formatting techniques to provide flexible highlighting, applying specified formatting only when certain conditions are met. Techniques include:

Data bars — to make it easy to visualize values in a range of cells.

Cells Rules — to highlight values that match the requirements you specify.

Explanation:

also refer the attachment